Use the PWXCATMY utility to create, prepare, and manage the PowerExchange catalog tables that are required for PowerExchange CDC for MySQL sources. The utility can also report information from the catalog tables.
The catalog tables store MySQL source table definitions. When PowerExchange receives DDL change events of CDC interest for the source tables, PowerExchange updates the source table definitions in the catalog to avoid errors when reading change data for the DDL-updated tables. Typically, these DDL changes are those that require you to re-create or modify the capture registrations and extraction maps for the source tables, for example, column add, drop, or rename operations and table drop or rename operations.
With this utility, you can perform the following tasks:
Create the catalog tables, PWXCatTables and PWXCatUpdates, in the MySQL source database or in another local or remote MySQL database.
Show the DDL statements for creating the catalog tables.
Verify that the catalog tables exist and have the correct format.
Create point-in-time snapshots of the source table definitions and write this information to the catalog. You must take an initial snapshot of all tables from which change data is captured prior to starting change data capture. In the utility, this task is called a REGISTER operation.
Remove source table definitions from the catalog. In the utility, this task is called a UNREGISTER operation.
List the source table names for which table definitions exist in the catalog.
Dump the source table definitions that are currently stored in the catalog.
Drop the catalog tables.
For more information about the catalog, see the
PowerExchange CDC Guide for Linux, UNIX, and Windows