Altering tables to support change data capture

If you did not choose to use a table for change data capture when you created it, you can alter the table so that you can use it for change capture.

Before you begin

Restrictions

  • You cannot alter a table for change data capture if the table contains record arrays.
  • A primary key must be defined.
  • The VSAM data set must reference a KSDS base cluster.
  • Your VSAM table should be defined using a DS data set and should not be defined using either a CICS VSAM mapping or a DD data set.

Procedure

  • To alter a table in a data design project:
    1. In the Data Project Explorer, select the table.
    2. On the General page of the Properties view, set the DATA CAPTURE flag to CHANGES.
    3. Generate the DDL for the table and run the DDL on a data server.
  • To alter a table that already exists in a metadata catalog:
    1. In the Data Source Explorer, expand the connection to your data server until you locate the table.
    2. Right-click the table and select Enable Change Capture.
    The change to the table takes effect immediately.