Oracle GoldenGate Error Messages

OGG-25256

DATA CAPTURE CHANGES enabled for SYSIBM.SYSCOLUMNS. This may allow the capture of table alterations when SYSIBM.SYSTABLES is also set for data capture and the DDL parameter is specified.


Cause

If DATA CAPTURE CHANGES is enabled for SYSIBM.SYSCOLUMNS and SYSIBM.SYSTABLES, then log information can be used to capture log records with tables alter information if the DDL parameter is also specified.


Action

Enable DATA CAPTURE CHANGES for both SYSIBM.SYSCOLUMNS and SYSIBM.SYSTABLES in DB2 if alter table log record processing is desired. Data capture for SYSIBM.SYSTABLES and SYSIBM.SYSCOLUMNS must be on, and the DDL parameter must be specified to enable this feature.