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

Creating a Snapshot of Source Table Definitions

After you create the catalog tables, create a snapshot of the source table definitions to initially populate the catalog. After you start CDC processing, PowerExchange updates the baseline table definitions in the catalog when it detects DDL change events of CDC interest from the MySQL binary log.

To create a snapshot of the source table definitions, use the PWXCATMY utility. Issue the following command for a REGISTER operation:

PWXCATMY OPERATION=REGISTER source_connection_parameters catalog_connection_parameters table_parameters

In the table_parameters, you can enter any of the following criteria to select the source tables for which to register table definitions in the catalog:

Specific table names

Table-name masks that include MySQL wildcards

The source instance name, as defined in the PowerExchange registration group for the source

For more information about this command, see the

PowerExchange Utilities Guide

Configuring PowerExchange for MySQL CDC

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal