Migration step 21: Enable change data capture

During migration to DB2® 10 conversion mode (from Version 8 or Version 9), DB2 disables change data capture on the catalog tables. If you want to use change data capture on these tables, you must re-enable it.

About this task

During enabling-new-function mode (from Version 8 or Version 9) processing, change data capture is disabled on catalog tables. Do not re-enable change data capture until your DB2 subsystem is in DB2 10 new-function mode.

To re-enable change data capture:

Issue the following statement for each table for which you want to re-enable change data capture:

ALTER TABLE SYSIBM.tablename DATA CAPTURE CHANGES;

Where tablename is the name of the catalog table.