Oracle GoldenGate Error Messages

OGG-00856

Table {0} does not have DATA CAPTURE CHANGES enabled for LONG columns. Use the TRANLOGOPTIONS NOREQUIRELONGDATACAPTURECHANGES parameter to override


Cause

DB2 LUW Data Capture Changes is not enabled for LONG columns on this table. The TRANLOGOPTIONS parameter is set to its default of REQUIRELONGDATACAPTURECHANGES, which forces Extract to abend when LONGs are not captured. When NOREQUIRELONGDATACAPTURECHANGES is used, Extract issues a warning and continues processing the record.


Action

Change TRANLOGOPTIONS to NOREQUIRELONGDATACAPTURECHANGES to avoid an abend, or enable capture of LONG columns.