Table of Contents

Search

  1. Preface
  2. Part 1: PowerExchange CDC Introduction
  3. Part 2: PowerExchange CDC Components
  4. Part 3: PowerExchange CDC Data Sources
  5. Part 4: Change Data Extraction
  6. Part 5: Monitoring and Tuning
  7. Appendix A: DTL__CAPXTIMESTAMP Time Stamps

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

Db2 Data Sources

Db2 Data Sources

PowerExchange captures change data from Db2 recovery log files for Db2 source tables on a Linux, UNIX, or Windows system.
For CDC to work, archive logging must be active for the database. Also, you must create a PowerExchange capture catalog table in the source database. The capture catalog table stores information about the source tables and columns, including Db2 log positioning information.
If you have a source table with user-defined fields or multi-field columns, you can create a data map to manipulate these fields with expressions. For example, you might want to create data map to manipulate packed data in a CHAR column. If you create a data map, you must still create a capture registration and merge the data map with the extraction map that is generated for the capture registration.

0 COMMENTS

We’d like to hear from you!