Oracle GoldenGate Error Messages

OGG-25129

DATA CAPTURE CHANGES enabled for SYSIBM.SYSTABLES. This may allow the capture of data related to SYSIBM.SYSTABLES when APIFILTER is used.


Cause

If APIFILTER is enabled and DATA CAPTURE CHANGES is enabled for SYSIBM.SYSTABLES, then APIFILTER can be used to capture systables data when filtering with a list of databases and table IDs.


Action

To enable DATA CAPTURE CHANGES for SYSIBM.SYSTABLES, use this GGSCI command: ADD TRANDATA sysibm.systables. This allows processing to be done with APIFILTER, when no other conditions exist that would force NOAPIFILTER. For example, the need to capture change data for any table that includes one or more LOB columns.