In my previous article, I talked about how to use the DB2 HADR feature as a tool to migrate data. Here is another cool method I discovered (entirely by accident) during one of my hair tearing migration sessions with the application team. I must say in all fairness the application team had more of a tough time than me, but once I discovered this cool feature in DB2 and tested it, I was able to sit back, relax and enjoy all the hustle and bustle that the application team had to go through. Read more… »
More “cool” data migration strategies!
October 12th, 2011 by Jeyabarathi(JB) Chakrapani No comments »HADR as a migration tool – a cool way to migrate data!!
July 21st, 2011 by Jeyabarathi(JB) Chakrapani 2 comments »In this article you can read about an unconventional and cool way of using the DB2 HADR tool for data migration. I presented this method of using the DB2 High Availability Disaster Recovery feature as a tool to migrate a database for the 2011 spring “DB2’s got talent” contest series hosted by Scott Hayes of the popular DB2 Night Show.
Hot Tip #2 – Software to manage all your server connections
July 15th, 2011 by Klaas Brant No comments »"Single sign-on" is a dream that for many for us is impossible. Servers, servers and more servers is what we are facing nowadays. And single sign-on is simply not possible because…
Hot Tip #1 – Simplify and Speed-up Downloads
June 25th, 2011 by Klaas Brant No comments »In our day to day job the use of internet is nowadays permitted in the larger companies. Software vendors store their manuals, white papers and software updates online so you can easily download it. There are two potential "problems" with downloading information
Extended explain in DB2 z/OS
December 6th, 2010 by Abe_Kornelis No comments »In 2010 I did extensive research on extended explain tables. This post shows the results of my research. Read more… »
DB2 for z/OS Private Protocol migration made easier by DRDA_RESOLVE_ALIAS
November 22nd, 2010 by Cristian Molaro No comments »Private Protocol (PP) distributed processing was deprecated in DB2 for z/OS V9 and it is not supported in DB2 10.The initial announcement was that any package marked as bound with PP will not execute in 10, but because this was an issue for installations where the BIND default was DBPROTOCOL(PRIVATE) this constraint was relaxed. Read more… »
FREE DB2 SQL Cookbook
November 18th, 2010 by Klaas Brant No comments »In one of my last blogs I wrote about free books published by IBM. I got lots of positive feedback. People like free stuff especially when it is good. So, today I give you another pointer to another great free book.
Read more… »
Free downloadable books from IBM
November 4th, 2010 by Klaas Brant 1 comment »Of course we all know about all the great IBM Red Books at http://www.redbooks.ibm.com/ but there is more… Read more… »
DB2 Handling -805 on SYSLH2?? packages
August 7th, 2010 by Cristian Molaro No comments »Did you ever encounter a SQLCODE -805 (SQLSTATE 51002) in a distributed dynamic SQL environment? A bit strange because the SQLCODE -805 says DBRM or package not found in plan, but we are dealing with dynamic SQL. Here is what happened… Read more… »
