In order for the Db2/z Capture Agent to be able to extract the changed data for Db2 tables from the recovery log, the source Db2 table must be altered to allow for change data capture.
Syntax
ALTER TABLE <schema.tablename> DATA CAPTURE CHANGES;
Keyword and Parameter Descriptions
| Keyword | Description |
|---|---|
| <schema.tablename> |
The fully qualified name of the source table for which changes are to be captured. |
Note: Enabling change data capture will increase the amount of data written to the Db2 recovery log for each update to the source data table. Depending on the size of the tables and the volume of updates made to the table, the size of the active Db2 logs may have to be adjusted to accommodate the increase data.