Oracle GoldenGate Error Messages

OGG-25285

The Extract is configured for DDL processing. System information from SYSIBM.SYSTABLES and SYSIBM.SYSCOLUMNS must have data capture changes enabled or the Extract cannot process DDL alter and create table log records.


Cause

If SYSIBM.SYSTABLES or SYSIBM.SYSCOLUMNS does not have change data capture enabled, these table should be altered to have change data capture allowing the Extract to process system information when DDL is configured.


Action

Enable change data capture for SYSIBM.SYSTABLES and SYSIBM.SYSCOLUMNS in DB2 if alter table log record processing is desired. Both tables must have this value enabled for alter and create table processing.