Each PWXCATMY command must include the OPERATION parameter. This parameter indicates the type of operation that the utility will perform.
The PWXCATMY utility can perform the following types of operations:
CREATE
Creates the catalog tables in a MySQL database on the catalog host machine. The catalog can be in the MySQL source database or in another local or remote MySQL database, which is on a Linux or Windows machine.
DROP
Drops the existing catalog tables.
DUMP
Dumps the last table definition that is recorded in the catalog. You can select the tables for which to dump table definitions based on a schema name, specific table names, table-name masks, or an instance name that is in a PowerExchange registration group definition for a MySQL source. Alternatively, you can specify a binary log coordinate to indicate a point in binary log for the DUMP operation. In this case, the DUMP operation displays the most recent MySQL table definition prior to the coordinate position.
LIST
Lists the source table names associated with the table definitions in the catalog, for either all MySQL servers or a source server that is accessed with the source connection parameters you specify.
REGISTER
Takes an initial point-in-time snapshot of the MySQL source table definitions and records the snapshot definitions in the catalog tables. You can select the tables for which to take a snapshot based on a schema name, specific table names, table-name masks, or the instance name from the PowerExchange registration group definition for the MySQL source. The easiest way to snapshot all tables that are registered for CDC under a registration group is to enter the instance name.
SHOWDDL
Displays the DDL statements for creating the catalog tables.
UNREGISTER
Removes source table definitions from the catalog. You can select the source tables for which to remove the definitions.
VERIFY
Verifies that the catalog tables exist and have the correct format.