Q Replication Packaging Revealed!

Posted by Frank Fillmore on March 9, 2011 under DB2 for Linux Unix Windows, DB2 for z/OS, InfoSphere, Q-Replication. Tags: , .

Led Zeppelin had a concert film, song, and album with the title “The Song Remains the Same”.  Even though it comes in different packaging, Q Replication functionality remains consistent. 

Data interoperability – what IBM calls Information Integration – is a core competency of The Fillmore Group.  We deliver consulting services and IBM authorized training for software products like Information Server (think DataStage), InfoSphere Change Data Capture (ne’e DataMirror), InfoSphere Federation Server, and more.

Right now we’re working a lot with DB2 Homogeneous Replication Feature and it’s sibling InfoSphere Replication Server.  BTW – a moment’s digression – what is the difference between these two?  Both feature what is commonly known as Q Replication: IBM’s high volume, low-latency, assured-delivery data replication solution.  The differences come down to licensing and capabilities.  When you install DB2 Enterprise Server Edition (DB2 ESE), all of the code for the DB2 Homogeneous Replication Feature is there.  To activate it, you must purchase and apply the appropriate license key.  This gives you the ability to create DB2 for LUW to DB2 for LUW replication topologies.  Of course DB2 for z/OS can be both a source and target for Q Replication, but the licensing to include DB2 for z/OS is beyond the scope of this post.  DB2 Advanced Enterprise Server Edition (DB2 AESE)  includes a limited-use license for the DB2 Homogeneous Replication Feature.  To learn more about the feature-rich DB2 AESE bundle, join us for a free webinar on Wednesday, March 16.  By contrast, InfoSphere Replication Server can replicate from and to heterogeneous sources and targets.  At one very large integrated financial services firm, Q Replication is being used to:

  • migrate Oracle databases to DB2 for AIX without taking an outage
  • populate a warm standby subsystem for DB2 for z/OS
  • integrate DB2 for z/OS data into an Oracle application
  • create a DB2 for AIX reporting database with near-real-time DB2 transactional data

Clear?  Good.  If not, drop me a note (frank.fillmore@thefillmoregroup.com) to talk about your specific replication use case.

Leave a Comment