Table of Contents

Search

  1. Preface
  2. PowerExchange CDC Publisher Overview
  3. Installing and Upgrading PowerExchange CDC Publisher
  4. PowerExchange CDC Publisher Key Concepts
  5. PowerExchange Change Capture Environment
  6. Apache Kafka Targets
  7. Configuring PowerExchange CDC Publisher
  8. Streaming Change Data
  9. Monitoring PowerExchange CDC Publisher
  10. Administering PowerExchange CDC Publisher
  11. Command Reference for the Command-Line Utilities
  12. Avro Schema Formats

User Guide

User Guide

PwxCDCPublisher Utility - Command and Parameters

PwxCDCPublisher Utility - Command and Parameters

Use the PwxCDCPublisher utility to create and run a change data stream from PowerExchange to a supported target.
Also, the PwxCDCPublisher utility has optional parameters that allow you to specify an instance subdirectory other than instanceA and to indicate the change stream position from which the PwxCDCPublisher will restart.

Syntax

The PwxCDCPublisher command has the following syntax:
PWXCDCPUBLISHER [INSTANCE=
override_instance_directory
] [RESTART={FROM_BEGINNING|FROM_END|FROM_CONFIG}] [COLDSTART={Y|
N
}] [HELP|?]
All parameters are optional. Use a single space as a separator between parameters.

Parameter Descriptions

INSTANCE=
override_instance_subdirectory
Overrides the default name or location of the instance subdirectory, which is
pwxcdcpub_root installation
\instanceA
. You can enter the fully qualified path of the subdirectory or a location that is relative to the root installation directory that is specified in the PWXPUB_HOME environment variable. For example, the following values specify the same directory location if PWXPUB_HOME=C:\Informatica\ PwxCdcPublisherInstall.1.0.0.windows.64bit:
instanceB
C:\Informatica\PwxCdcPublisherInstall.1.0.0.windows.64bit\instanceB
RESTART=[{FROM_BEGINNING|FROM_END|FROM_CONFIG}]
Overrides the default change stream position from which the PwxCDCPublisher process restarts after it is stopped or ends abnormally. To indicate the change stream position, enter one of the following options:
  • FROM_BEGINNING
    . Extract change data from the earliest record that is available in the PowerExchange Logger log files.
  • FROM_END
    . Extract change beginning from the last processed record in the PowerExchange Log log files.
  • FROM_CONFIG
    . Extract change data from the specific change stream position that you identify in the Extract.restart1 and Extract.restart2 properties in the Extractor configuration file. This option is equivalent to setting COLDSTART=Y.
    The Extract.restart1 and Extract.restart2 properties specify the PowerExchange sequence token and restart token values, respectively. For more information about these PowerExchange token values, see the PowerExchange CDC documentation or contact Informatica Global Customer Support.
By default, the first time you start the PwxCDCPublisher, it starts from the earliest position in the PowerExchange Logger log files, as if FROM_BEGINNING was specified. Subsequent PwxCDCPublisher runs start from the last position of the prior run. If you want it to start from a different position, use the RESTART parameter. Do not also specify the COLDSTART parameter.
COLDSTART={Y|
N
}
Indicates whether to cold start the PwxCDCPublisher process. If you specify COLDSTART=Y, the process begins extraction processing from the change stream position that you specify in the Extract.restart1 and Extract.restart2 properties in the cdcPublisherPowerExchange.cfg configuration file. The COLDSTART=Y setting is equivalent to the RESTART=FROM_CONFIG setting. COLDSTART=N indicates a cold start will not occur.
Issue either the COLDSTART or RESTART parameter. Do not specify both parameters.
Default value is N.
HELP or ?
Displays help information about the PwxCDCPublisher parameters.

0 COMMENTS

We’d like to hear from you!