Enabling Change Capture

Follow these steps to configure DB2 to log data changes in the expanded format that is supplied by the DATA CAPTURE CHANGES feature of the CREATE TABLE and ALTER TABLE commands. This format provides Oracle GoldenGate with the entire before and after images of rows that are changed with update statements.

From the Oracle GoldenGate directory, run GGSCI.

Log on to DB2 from GGSCI as a user that has ALTER TABLE privileges.

DBLOGIN SOURCEDB DSN, USERID user[, PASSWORD password][, encryption_options]

Issue the following command. where table is the fully qualified name of the table. You can use a wildcard to specify multiple table names but not owner names.
```
ADD TRANDATA table
```
By default, ADD TRANDATA issues the following command:
```
ALTER TABLE name DATA CAPTURE CHANGES;
```