|
Integrated Synchronization
|
CDC
|
Installation and setup
|
Streamlined and optimized design tailored specifically for Db2 z/OS -> Db2 Analytics Accelerator replication, resulting in less CPU consumption and better throughput
|
General purpose replication technique supporting multiple sources and targets
|
|
New log data provider component integrated into Db2 for z/OS for capturing table updates from the Db2 for z/OS log. Initial installation by applying a Db2 for z/OS PTF. New log data processor component integrated into Db2 Analytics Accelerator.
|
CDC capture agent installation and setup required for capturing table updates from the Db2 for z/OS log.
CDC apply components are included in Db2 Analytics Accelerator.
|
|
Supported with Db2 12 only
Minimum prerequisite: Function level V12R1M500 with APAR PH06628 (PTF UI63356)
|
Supported with Db2 11 and Db2 12
|
|
Log data provider maintained by applying Db2 PTFs
|
CDC capture agent maintained by applying CDC PTFs
|
|
Db2 DDF secure port and AT-TLS network encryption setup required
|
No encryption required, but optional configuration of encryption of data-in-motion possible
|
|
Optional support for RACF PassTickets for Db2 z/OS authentication from accelerator via Db2 DDF as an alternative to user ID/password authentication method
|
Db2 for z/OS authentication from accelerator via Db2 DDF with user ID/password only.
|
|
High-Availability setup for log data provider component in data sharing environments on the roadmap
|
High-Availability setup of the CDC capture agent in data sharing environments supported
|
CPU usage and latency
|
50% less CPU consumption on z/OS compared to CDC.
|
Higher CPU consumption on z/OS
|
|
This workload to capture changes from the Db2 log is fully zIIP enabled
|
Full CDC Capture Agent workload to capture changes from Db2 log runs on GP processors (not zIIP enabled)
|
|
Significant reduction in replication latency.
Latency < 10 seconds
|
Latency around 30 seconds, can be more or less depending on workload. Higher with significant “True HTAP” workload.
|
|
“True HTAP” query scalability significantly improved. Usage of WAITFORDATA protocol for concurrent queries has practically no impact on throughput and latency
|
Usage of WAITFORDATA protocol for queries may impact replication throughput and latency
|
Functional differences
|
Replication of Db2 archive tables (Transparent Archiving) supported
|
No support of replication of Db2 archive tables (Transparent Archiving), because of a CDC limitation
|
|
On the roadmap:
- Option to change the IP address of the Log Data Provider on the accelerator
- Automatically disable query acceleration when table no longer replicated
- Replication of schema changes (First stage: ALTER TABLE xxx ADD COLUMN)
|
Currently there are no plans to make any additional features available for CDC usage (such as the ones that are on the roadmap for Integrated Synchronization).
|