In order for the UDB Log Reader Capture Agent to be able to extract the changed data for UDB tables from the recovery log, each source UDB table must be altered to allow for change data capture.
Syntax
$ Db2 connect to <database_name>
Db2 => 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 UDB 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 UDB logs may have to be adjusted to accommodate the increase data.