User Guide

1.1
- 1.3
- 1.2
- 1.0

Back Next

Restarting a PowerExchange CDC Publisher Change Data Stream

If a PowerExchange CDC Publisher process is shut down or ends for any reason, you can use the PwxCDCPublisher utility to restart it from the default restart position in the PowerExchange Logger for Linux, UNIX, and Windows log files or from an override restart position that you set by using the PwxCDCPublisher RESTART or COLDSTART parameter.

By default, the first time you start the PwxCDCPublisher for a particular instance, it starts from the earliest position in the PowerExchange Logger log files. Subsequent PwxCDCPublisher runs start from the last position of the prior run unless you specify an override position. If you plan to override this default position by using the RESTART FROM_BEGINNING or FROM_CONFIG option or the COLDSTART=Y setting, first delete the existing checkpoint file.

At the command prompt, enter the PwxCDCPublisher command without the RESTART or COLDSTART parameter to restart the Publisher process from the default restart position. To override the default restart position, include the optional RESTART or COLDSTART parameter. Also include the optional INSTANCE parameter if you are restarting a PwxCDCPublisher process that is using an instance other than the default "instanceA" at

/pwxcdcpub_root installation/instanceA

You can issue the command from the

pwxcdcpub_root_installation\bin

subdirectory or from another location if you specified the PWXPUB_HOME environment variable.

Use the following syntax:

PWXCDCPUBLISHER [RESTART={FROM_BEGINNING|FROM_END|FROM_CONFIG}] [COLDSTART={Y| N}] [INSTANCE=override_instance_directory]

In this syntax:

RESTART. Overrides the default restart position. Select one of the following options to specify the location in the change stream from which to restart Publisher processing:

FROM_BEGINNING. Extract change data from the earliest record that is available in the PowerExchange Logger log files, which is the same as the default start position for the first run of the PowerExchange CDC Publisher.

FROM_END. Extract change data beginning from the last processed record in the PowerExchange Logger 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 cdcPublisherPowerExchange.cfg 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.

COLDSTART. Set this parameter to Y to cold start the PwxCDCPublisher process from the specific position in the PowerExchange Logger log files that is identified by the Extract.restart1 and Extract.restart2 properties. This setting is equivalent to RESTART=FROM_CONFIG. Do not specify the COLDSTART=Y parameter with the RESTART parameter.

For more information about the command syntax, see PwxCDCAdmin Utility - Command and Parameters.

The following example output is from a PWXCDCPublisher RESTART=FROM_END command:

  INSTANCE = instanceA. CDC Publisher Started. Listening on host:port USHOST1:26987
  ------------------------------------------------------------------------------
PWX-07122 DTLSCLI connected using DTLConnect PWX Version: 10.1.1, Patch Level:
V1011_B05_5095439, Local code pages: Control=UTF-8 (41) Data=ISO-8859 (1) SQL=UTF
-8 (41).
  Running...
PWX-33304 Connection: 10.17.3.191:49363, Type: CAPXRT, Task ID: 0, Operation 
timeout: (-) secs, Heartbeat interval: 30 secs, Session: (-)
PWX-33304 Connection: 10.17.3.191:49369, Type: CAPXRT, Task ID: 0, Operation 
timeout: (-) secs, Heartbeat interval: 30 secs, Session: (-)
PWX-33304 Connection: 10.17.3.191:49363, Type: CAPXRT, Task ID: 0, Operation 
timeout: (-) secs, Heartbeat interval: 30 secs, Session: (-)
PWX-31517 To retrieve extraction maps, PowerExchange uses the value for Map 
Location, 'mylaptop_v1000', from the PWX CDC application connection.
PWX-33304 Connection: 10.17.3.191:49363, Type: CAPXRT, Task ID: 0, Operation 
timeout: (-) secs, Heartbeat interval: 30 secs, Session: (-)
PWX-07122 DTLSCLI connected using DTLConnect PWX Version: 10.1.1, Patch Level: 
V1011_B05_5095439, Local code pages: Control=UTF-8 (41) Data=ISO-8859 (1) SQL=UTF
-8 (41).

Administering PowerExchange CDC Publisher

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal