This post is the answer to one of the FAQs found in
With the move towards integrated software stacks, you may not be aware of all the software technologies you have in the products you own. IBM InfoSphere Data Replication's Q and SQL Replication are two that people often ask about. They're found in several IBM products and people don't always know they have them. To cut down on confusion, I put together a quick reference of sorts. However, please note that this table is only about which products install the technologies. It is not a statement about what the technologies support. They support more products than those listed here. For example, Q and SQL Replication are used extensively with DB2 z/OS and Information Server's DataStage even though they are not installed by those products.
|Product||SQL Replication*||Q Replication|
|DB2 for Linux, UNIX, and Windows||**|
|IBM Smart Analytics Systems||**||More information is on ChannelDB2.com|
|IBM InfoSphere Data Replication (IIDR)||Replaces InfoSphere Replication Server***|
|i5/OS (aka iSeries)||In an operating system feature called DB2 DataPropagator|
** While Q Replication is installed as part of all these products, a license must be acquired before you can use it. How? You can be licensed for Q Replication through IIDR, DB2 Advanced ESE/InfoSphere Warehouse, or InfoSphere Replication Server 9.7. All also include a copy of WebSphere MQ at no additional cost.
*** Only IIDR and Replication Server contains Q and SQL Replication's heterogeneous function (support for Oracle, Sybase ASE, etc.).