The IBM® Db2® Analytics Accelerator (Accelerator) is a logical extension of Db2 for IBM z/OS® that provides a high-speed query engine that efficiently and cost-effectively runs analytics workloads. The Accelerator is an integrated back-end component of Db2 for z/OS. Together, they provide a hybrid workload-optimized database management system that seamlessly manages queries that are found in transactional workloads to Db2 for z/OS and queries that are found in analytics applications to Accelerator. Each query runs in its optimal environment for maximum speed and cost efficiency.
The incremental update function of Db2 Analytics Accelerator for z/OS updates Accelerator-shadow tables continually. Changes to the data in original Db2 for z/OS tables are propagated to the corresponding target tables with a high frequency and a brief delay. Query results from Accelerator are always extracted from recent, close-to-real-time data.
An incremental update capability that is called IBM InfoSphere® Change Data Capture (InfoSphere CDC) is provided by IBM InfoSphere Data Replication for z/OS up to Db2 Analytics Accelerator V7.5. Since then, an extra new replication protocol between Db2 for z/OS and Accelerator that is called IBM Integrated Synchronization was introduced. With Db2 Analytics Accelerator V7.5, customers can choose which one to use.
IBM Integrated Synchronization is a built-in product feature that you use to set up incremental updates. It does not require InfoSphere CDC, which is bundled with IBM Db2 Analytics Accelerator.
In addition, IBM Integrated Synchronization has more advantages:
IBM Db2 for z/OS Data Gate simplifies delivering data from IBM Db2 for z/OS to IBM Cloud® Pak® for Data for direct access by new applications. It uses the special-purpose integrated synchronization protocol to maintain data currency with low latency between Db2 for z/OS and dedicated target databases on IBM Cloud Pak for Data.
Use cases that bring business value to IBM Integrated Synchronization
Introduction to IBM Integrated Synchronization
Benchmarks, CPU and elapsed time metrics, and comparisons with InfoSphere CDC
Comparing InfoSphere Change Data Capture and IBM Integrated Synchronization
Different scenarios for data sharing
Setup details, prerequisites and recommended maintenance, and installation and configuration
Prerequisites and recommended maintenance
Security setup in RACF
Security setup for network
Network setup for data sharing groups
Accelerator setup for incremental updates
Installation experiences from other customers
Enabling tables for replication
Replicated tables in error
IBM Integrated Synchronization externals in Db2 for z/OS