CDC Guide for i5/OS

10.5
- 10.5.8
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Changing a DB2 Table Definition

Occasionally, you might need to change the definition of a DB2 source table that is registered for change data capture.

If your changes affect columns from which change data is captured, use this procedure to enable PowerExchange to switch to the updated table definition, while preserving access to previously captured data.

Perform this procedure whenever you add, alter, or drop columns for which change data is captured. You do not need to perform this procedure if you are selectively capturing change data for a subset of columns and none of the selected columns are affected by the metadata changes.

If you no longer need to capture change data from a column in a table, you can remove the column from the extraction map without changing the capture registration. Change data for that column is still captured but is not extracted.

To change a DB2 source table definition:

Stop all transactions, applications, and other activity that update the table.

Verify that any change data that was captured under the previous table definition has completed extraction processing. Then stop all workflows that extract change data for the table.

In the PowerExchange Navigator, open the original capture registration and set its status to

History

Use DDL to make the table changes.

In the PowerExchange Navigator, create a capture registration that reflects the metadata changes and set its status to

Active

PowerExchange uses the newly activated capture registration for change data capture.

If necessary, change the target table definition to reflect the source table metadata changes.

In PowerCenter Designer, import the altered source and target tables. Edit the mapping if necessary.

Rematerialize the target tables, if necessary. After materialization completes, create restart tokens.

Enable transactions, applications, and other activity to update the table again.

Rename Saved Search

Table of Contents

CDC Guide for i5/OS

CDC Guide for i5/OS

Changing a DB2 Table Definition

Changing a DB2 Table Definition