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 the Structure of a MySQL Source Table

Occasionally, you might need to make DDL changes to a registered MySQL source table that add, alter, or drop columns from which PowerExchange captures changes. You can switch to the new table definition in a manner that preserves access to previously captured data.

This topic describes the steps for properly switching to a new table definition.

You do not need to perform these steps in the following situations:

You selectively capture change data for a subset of columns, and the DDL changes do not affect any of these columns or their ordinal values.

You need to stop change data extraction processing for a column. In this case, remove the column from the extraction map and do not edit the capture registration. PowerExchange still captures change data for the column but does not extract it when CDC sessions run.

Stop data change activity (inserts, updates, and deletes) on the table.

Verify that any change data that was captured under the current table definition has completed extraction processing. Then stop all PowerCenter 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, open the original capture registration and set its status to

History

PowerExchange does not capture change data based on capture registrations that have a status of

History

Inactive

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

Make the DDL changes to the table.

In the PowerExchange Navigator, create a new capture registration for the table that reflects the DDL changes.

Make sure that you include these settings:

In the

Condense

list, select

Part

In the

Status

list, select

Active

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

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

Change the target table definition to reflect the source table changes, if necessary.

In PowerCenter Designer, import the new extraction map for the altered source table to create a new source definition. Also, if you changed the target table, edit or re-create the target definition. Then, edit the mapping, if necessary.

If necessary, rematerialize the target tables and then create new restart tokens.

Allow change activity on the table to resume.

Start the PowerCenter workflows again.

Extraction processing resumes.

Managing MySQL CDC

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

Changing the Structure of a MySQL Source Table

Changing the Structure of a MySQL Source Table