Incremental updates

The incremental update function of IBM Db2 Analytics Accelerator for z/OS® allows you to update accelerator-shadow tables continually. Changes to the data in original Db2 for z/OS tables are thus propagated to the corresponding target tables with a high frequency and just a brief delay. This way, query results from an accelerator are always extracted from recent, close-to-real-time data.

The product offers the following options to implement incremental updates:

• IBM Integrated Synchronization
• IBM InfoSphere® Change Data Capture for z/OS (CDC)

If you chose CDC as your implementation option, you already installed the necessary CDC components by completing the steps in Installing libraries with IBM Db2 Analytics Accelerator support. However, for updates or more detailed information, follow the link to the installation instructions in the IBM InfoSphere Change Data Capture for z/OS information center at the end of this topic.

Incremental update processing requires a setup on the mainframe as well as on the accelerator. For change processing on the mainframe, the following feature or product exists: