CDC Guide for Linux, UNIX, and Windows

10.5
- 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 Source Table Definition

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

If you make table definition changes that affect the columns from which change data is captured, perform this procedure to enable PowerExchange to switch to the updated table definition, while preserving access to previously captured data. These table definition changes include adding, altering, or dropping columns. Do not 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 table definition 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.

Stop all transactions, applications, and other activity that update the source 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.

If you use the PowerExchange logger for Linux, UNIX, and Windows, shut down the Logger.

In the PowerExchange Navigator, delete the original capture registration and extraction map.

Use DDL to make the table changes.

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

Active

. A corresponding extraction map is generated.

When you create the capture registration, use the original registration name so that you will not need to the edit the map name that is used by the PowerCenter CDC workflows that contain the changed source table.

If you shut down the PowerExchange Logger, warm start it.

The PowerExchange Logger begins capturing changes based on the new capture registration.

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

In PowerCenter Designer, import the extraction map for the altered source table to create a new source definition. Edit the mapping if necessary.

If you also changed the target table, edit or re-create the target definition. Then edit the mapping, if necessary.

If necessary, rematerialize the target tables. After materialization completes, create new restart tokens.

Enable update activity on the source table again.

Restart the PowerCenter workflows.

If the table definition changes affected columns of CDC interest or you needed to edit the mapping, cold start the session. Otherwise, warm start the session.

Rename Saved Search

Table of Contents

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

Changing a Db2 Source Table Definition

Changing a Db2 Source Table Definition