IBM Db2 11 Changes to Data Replication

News

Abstract

Some Data Replication technology previously included in IBM Db2® Advanced Editions (AESE/AWSE) prior to v11.5 is no longer included in some Db2 11.5 editions.

What changed?
Db2 v11.5 no longer includes replicating data with Q-Rep between up to 3 instances of Db2, nor replicating data with CDC between two instances of exactly the same Db2 edition/version ONLY for HADR.

What stays the same?
Db2 v11.5 continues to include replicating data with SQL Rep between Db2 LUW editions, and supporting Shadow Tables with CDC.

Content

The Db2 LUW v11.5 edition changes and impact on data replication

Some Data Replication technology previously included in Db2 Advanced Editions (AESE/AWSE) prior to v11.5 is no longer included in some Db2 v11.5 editions.

When you upgrade to Db2 v11.5, you can continue to use data replication by purchasing IBM InfoSphere Data Replication for Db2 (IIDR for Db2). This allows you to pay for only what you use.

IBM Db2 v10.x, v11.1: Bundled Data Replication Entitlements

Available Capabilities	SQL Replication	Q Replication	CDC
Versions of Db2 Where Included	All Except Express-C	AESE, AWSE, Dev, PDOA, PDTX	AESE, AWSE, Dev, PDTX
Analytics use cases	þ	þ	NO
Disaster recovery use cases	þ	þ	þ
Multi-directional replication	þ	þ	NO
Transformations	þ	þ	NO
Replication between more than 2 other members	þ	NO	NO
Replication with members at different versions	þ	þ	NO
Replication to or from Db2 z/OS	NO	NO	NO
Replication to or from Db2 System i	NO	NO	NO
Replication to or from Db2 Warehouse	NO	NO	NO
Replication to Informix	NO	NO	NO
Replication to or from Non-IBM DB	NO	NO	NO
Event publishing	NO	NO	NO
Replication to Db2 shadow table	NA	NA	þ

Db2 v11.5: Remaining bundled Data Replication Entitlement

Available Capabilities	SQL Replication	Q Replication	CDC
Versions of Db2 Where Included	All Except Express-C	AESE, AWSE, Dev, PDOA, PDTX	AESE, AWSE, Dev, PDTX
Analytics use cases	þ	NO	NO
Disaster recovery use cases	þ	NO	NO
Multi-directional replication	þ	NO	NO
Transformations	þ	NO	NO
Replication between more than 2 other members	þ	NO	NO
Replication with members at different versions	þ	NO	NO
Replication to or from Db2 z/OS	NO	NO	NO
Replication to or from Db2 System I	NO	NO	NO
Replication to or from Db2 Warehouse	NO	NO	NO
Replication to Informix	þ	NO	NO
Replication to or from Non-IBM DB	þ	NO	NO
Event publishing	NO	NO	NO
Replication to Db2 shadow table	NO	NO	þ

IBM InfoSphere Data Replication for Db2 (IIDR for Db2) License

Available Capabilities	Q Replication	CDC
Versions of Db2 Where Included	AESE, AWSE, Dev, PDOA, PDTX	AESE, AWSE, Dev, PDTX
Analytics use cases	þ	NO
Disaster recovery use cases	þ	þ
Multi-directional replication	þ	NO
Transformations	þ	NO
Replication between more than 2 other members	NO	NO
Replication with members at different versions	þ	NO
Replication to or from Db2 z/OS	NO	NO
Replication to or from Db2 System I	NO	NO
Replication to or from Db2 Warehouse	NO	NO
Replication to Informix	NO	NO
Replication to or from Non-IBM DB	NO	NO
Event publishing	NO	NO
Replication to Db2 shadow table	NA	þ

IBM InfoSphere Data Replication (IIDR) License

Available Capabilities	SQL Replication	Q Replication	CDC
Versions of Db2 Where Included	Sold Separately	Sold Separately	Sold Separately
Analytics use cases	þ	þ	þ
Disaster recovery use cases	þ	þ	þ
Multi-directional replication	þ	þ	þ
Transformations	þ	þ	þ
Replication between more than 2 other members	þ	þ	þ
Replication with members at different versions	þ	þ	þ
Replication to or from Db2 z/OS	þ	þ	þ
Replication to or from Db2 System I	NA	NA	þ
Replication to or from Db2 Warehouse	þ	þ	þ
Replication to Informix	þ	þ	þ
Replication to or from Non-IBM DB	þ	þ	þ
Event publishing	NA	þ	NA
Replication to Db2 shadow table	NA	NA	þ

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTRGZ","label":"InfoSphere Data Replication"},"ARM Category":[{"code":"a8m0z0000001gSjAAI","label":"CDC"},{"code":"a8m0z0000001gT3AAI","label":"SQL\/Q Replication"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]

Product Synonym

IBM Data Replication
IDR
IBM InfoSphere Data Replication
IIDR
Change Data Delivery
CDD

Was this topic helpful?

Document Information

More support for:
InfoSphere Data Replication

Component:
CDC, SQL/Q Replication

Software version:
All Version(s)

Document number:
6346629

Modified date:
17 November 2020

UID

ibm16346629

IBM Support

Tips