CDC Guide for Linux, UNIX, and Windows

10.4.0 HotFix 1
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0

Back Next

Creating the DDL-Updated Catalog Tables

Before you begin capturing changes, you must create the catalog tables, PWXCatTables and PWXCatUpdates, in the MySQL source database or in another local or remote MySQL database. You can create the catalog tables either by running DDL statements manually or by using the PWXCATMY utility.

To create the catalog tables from the PWXCATMY utility, issue the following command from the PowerExchange root directory, where the utility is installed:

PWXCATMY OPERATION=CREATE CATHOSTNAME=catalog_host_name CATUSERNAME=catalog_user_name  CATPASSWORD=user_password CATSCHEMA=catalog_schema

The utility creates the tables on the specified catalog host.

To create the catalog tables manually, first get the DDL statements for creating the tables in the proper format by performing a SHOWDDL operation in the PWXCATMY utility. Issue the following utility command: