Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • PowerExchange for CDC and Mainframe 10.5
  • All Products

Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange Utilities
  3. createdatamaps - Data Map Creation Utility
  4. DTLCCADW - Adabas PCAT Utility
  5. DTLCUIML - IMS Log Marker Utility
  6. DTLINFO - Release Information Utility
  7. DTLREXE - Remote Execution Utility
  8. DTLUAPPL - Restart Token Utility
  9. DTLUCBRG - Batch Registration Utility
  10. DTLUCDEP - CDEP Maintenance Utility
  11. DTLUCSR2 - IDMS SR2 and SR3 Records Utility
  12. DTLUCUDB - DB2 for Linux, UNIX, and Windows CDC Utility
  13. DTLULCAT and DTLULOGC - IDMS Log Catalog Utilities
  14. DTLURDMO - Data Map Utility
  15. DTLUTSK - Task Control Utility
  16. EDMLUCTR - Log Scan and Print Utility
  17. EDMUOPTS - Service Aid Utility
  18. EDMXLUTL - Event Marker Utility
  19. HOSTENT - TCP/IP Address Reporter Utility
  20. PWXCATMY - MySQL Catalog Utility
  21. PWXUCCLPRT - Print Log Summary Utility
  22. PWXUCDCT - Logger for Linux, UNIX, and Windows Utility
  23. PWXUCREG - Capture Registration Suspend Utility
  24. PWXUCRGP - Capture Registrations Print Utility
  25. PWXUDMX - Data Maps Update Time ECSA Memory Utility
  26. PWXUGSK - SSL Reporting Utility
  27. PWXUMAP - Map List Utility
  28. PWXUSSL - PowerExchange SSL Reporting Utility
  29. WRKJRNLCKE- Journal Lock Table Utility for IBM i

Utilities Guide

Utilities Guide

Back Next

Command Syntax and Parameters

Command Syntax and Parameters

The parameters that you can enter with the PWXCATMY command vary by operation type.
To get help information about a command for any operation type, use the following command: 
PWXCATMY HELP=
operation_type
Where
operation_type
 is CREATE, DROP, DUMP, LIST, REGISTER, SHOWDDL, UNREGISTER, or VERIFY.

Command Syntax by Operation Type

Use the following syntax to issue a PWXCATMY command for a specific operation type. In the syntax, square brackets [ ] indicate optional parameters. After the initial PWXCATMY command, you can enter the parameters in any order.
For a CREATE operation: 
PWXCATMY OPERATION=CREATE 
catalog_connection_parameters
For a DROP operation: 
PWXCATMY OPERATION=DROP 
catalog_connection_parameters
For a DUMP operation: 
PWXCATMY OPERATION=DUMP 
source_connection_parameters
 
catalog_connection_parameters
 
table_parameters
 [COORD=
coordinate_parameter
]
For a LIST operation: 
PWXCATMY OPERATION=LIST [
source_connection_parameters
] 
catalog_connection_parameters
For a REGISTER operation: 
PWXCATMY OPERATION=REGISTER 
source_connection_parameters
 
catalog_connection_parameters
 
table_parameters
For a SHOWDDL operation: 
PWXCATMY OPERATION=SHOWDDL
For a UNREGISTER operation: 
PWXCATMY OPERATION=UNREGISTER 
source_connection_parameters
 
catalog_connection_parameters
 
table_parameters
For a VERIFY operation: 
PWXCATMY OPERATION=VERIFY 
catalog_connection_parameters

Command Parameters

catalog_connection_parameters
CATHOSTNAME={
catalog_host_name
|
localhost
}
Optional. The host name or IP address of the system that contains the catalog tables for MySQL sources, or the value
localhost
 if the catalog is on the system where PWXCATMY runs. Default is
localhost
.
To use a port number other than the default port, append the port number in the following format:
host_name
,
port_number
.
CATUSERNAME=
catalog_host_username
A user name that has the privileges required to connect to the catalog host during a PWXCATMY operation. This user must have CREATE, DROP, SELECT, UPDATE, and DELETE privileges on the catalog tables.
CATPASSWORD=
catalog_host_password
The password that is associated with the specified catalog user.
CATSCHEMA=
catalog_table_schema
The name of the schema for the catalog tables.
COORD=
binlog_coordinate
A binary log coordinate that you can optionally use to mark a point in binary log for a DUMP operation. With this parameter, the DUMP operation displays the most recent source table definition prior to this coordinate position. Without this parameter, the DUMP operation displays the last table definition in the catalog.
source_connection_parameters
HOSTNAME={
source_host_name
|
localhost
}
Optional. The host name or IP address of the MySQL source system.
To use a port number other than the default port, append the port number in the following format:
host_name
,
port_number
.
USERNAME=
source_host_username
Required. A user name that has the authority to connect to the source. This user must have at least the SELECT privilege on the source tables.
PASSWORD=
source_host_password
Optional. The password that is associated with the specified user.
table_parameters
Enter at least one of the following parameters to identify the source tables to register or dump:
SCHEMA=
source_schema_name
The schema name to use by default for any source table names that are specified without a schema for REGISTER or DUMP operations. You can enter this parameter only once.
TABLE=
source_table
A MySQL source table name. You can enter this parameter multiple times, each for a different source table.
MATCH=
source_table_mask
A pattern that matches one or more source table names. The mask specifies part of table name and uses the MySQL percentage (%) and underscore (_) wildcard characters to represent the remaining portion or portions. The percentage (%) character represents zero or more characters, and the (_) score represents a single character only. You can enter this parameter multiple times, each for a different set of source tables.
INSTANCE=
source_instance
An instance name that appears in a PowerExchange registration group definition for a MySQL source in the PowerExchange Navigator. The easiest way to snapshot all tables that are registered for CDC under a registration group is to enter the instance name.
0 COMMENTS
We’d like to hear from you!