Table of Contents

Search

  1. Preface
  2. Summary of PowerExchange New Features and Changes
  3. PowerExchange Installation and Upgrade
  4. PowerExchange Agent
  5. PowerExchange Client for PowerCenter
  6. PowerExchange Condense
  7. PowerExchange Listener
  8. PowerExchange Logger for Linux, UNIX, and Windows
  9. PowerExchange Navigator
  10. PowerExchange Monitoring and Tuning
  11. PowerExchange Utilities
  12. PowerExchange for Adabas
  13. PowerExchange for CA Datacom
  14. PowerExchange for DB2 for i
  15. PowerExchange for DB2 for Linux, UNIX, and Windows
  16. PowerExchange for DB2 for z/OS
  17. PowerExchange for CA IDMS
  18. PowerExchange for IMS
  19. PowerExchange for Microsoft SQL Server
  20. PowerExchange for MySQL
  21. PowerExchange for Oracle
  22. PowerExchange for PostgreSQL
  23. PowerExchange for VSAM and Flat Files
  24. PowerExchange ODBC

DBMOVER Configuration File

DBMOVER Configuration File

The MYSQL CAPI_CONNECTION statement in the DBMOVER configuration file can now include the following parameters in support of the new DDL-updated catalog of MySQL source table definitions:
CATSERVER=
server_name
Optional. The name of the server that contains the DDL-updated catalog tables that store source table definitions.
Default is the MySQL source server name. You can use the default if you created the catalog tables and installed the MySQL ODBC drivers on the source server.
CATSCHEMA=
schema_name
Required. The name of the schema for the DDL catalog tables.
CATUSERNAME=
user_name
Optional. A user name that is used to connect to the catalog server.
Default is the MySQL source user name if the catalog tables exist on the source server.
CATEPASSWORD=
encrypted_password
Optional. The encrypted password of the specified catalog user. Specify either CATEPASSWORD or CATPASSWORD but do not specify both parameters.
Default is the password of the MySQL source user if the catalog tables exist on the source server.
CATPASSWORD=
password
Optional. The clear-text password of the specified catalog user. Specify either CATPASSWORD or CATEPASSWORD but do not specify both parameters.
Default is the password of the MySQL source user if the catalog tables exist on the source server.
ONTABLEDDL={WARN|
WARN-UNTIL-EOL
|FAIL}
Optional. Indicates whether PowerExchange issues a warning message and continues processing or ends abnormally when it encounters a DDL record for a source that is not consistent with the source registration. Options are:
  • WARN. Issue a warning message and continue capture processing.
  • WARN-UNTIL-EOL. Issue a warning message and continue capture processing until the end-of-log (EOL). Then issue an error message and terminate capture processing.
  • FAIL. Issue an error message and terminate capture processing.
Default is WARN-UNTIL-EOL.
For more information, see the "DBMOVER Configuration File" chapter of the
PowerExchange Reference Manual
.

0 COMMENTS

We’d like to hear from you!