Thursday’s Q-Replication Challenges

Posted by Frank Fillmore on October 2, 2008 under Data Studio, Q-Replication. Tags: , , , .

Hat’s off to Kim for getting our blog off the ground. From the initial request from IBM, to reading “Blogging for Dummies” (yes, there really is such a book), to the artwork, format, and technical underpinnings, I’m just along for the ride.

Today’s entry comes after a long day of trying to create a DB2 for z/OS to DB2 for z/OS Q Replication environment at a very large financial institution (yes, there still really is such a thing). If you’re not familiar with Q Replication, it’s IBM’s “low-latency” – that means very little lag between when a transaction is committed on the source system and when it appears on the target – means of getting data from one database to another. This particular project is to provide high-availability, but other customers use Q Replication to populate near-real-time data warehouses.

While there’s a wealth of documentation on Q Replication (see the developerWorks web site at http://www.ibm.com/developerworks/db2/roadmaps/qrepl-roadmap.html) there are a few things that aren’t readily apparent.

The traditional DB2 administration Java-based fat client for Windows called Control Center is being phased-out over time in favor of IBM’s new browser-based thin client Data Studio. While Q Replication environments will still be built and administered via Replication Center (part of Control Center) in the near term, Data Studio Administration Console has already taken the place of the Q Replication Dashboard. Look for this and other cool Q Replication Tools at http://www-01.ibm.com/support/docview.wss?&rs=3171&uid=swg27007070

Many customers have experienced problems using Replication Center to build Q Replication environments against DB2 for z/OS databases. The alternative is to use the ASNCLP scripting language and forsake the Replication Center GUI. More on the ASNCLP – including a brief primer with a simple example – in my next post.

More