User Guide

1.3
- 1.2
- 1.1
- 1.0

Back Next

Determining the Status of CDC Publisher Processes

To determine the overall status of PowerExchange CDC Publisher processes, run the PwxCDCInfo utility with the STATUS parameter. To provide status information for each CDC Publisher process (Extractor, Formatter, and Connector), include the optional DETAIL parameter.

You can use this information to determine if a CDC Publisher process stopped or has a potential problem.

Before you issue the PwxCDCInfo command, ensure that the PowerExchange CDC Publisher process is running in a separate command line window.

At the command prompt, enter the PwxCDCInfo command with the STATUS parameter. Include the optional INSTANCE parameter if the Publisher process is using an instance other than the default "instanceA" at

/pwxpub_root installation/instanceA

Use the following syntax:

PwxCDCInfo STATUS [DETAIL [VERBOSE]] [INSTANCE=override_instance_directory]

You can issue the command from the

pwxcdcpub_root_installation\bin

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

For the full command syntax, see PwxCDCInfo Utility - Command and Parameters.

The command output is displayed on screen. Optionally, you can direct the output to a file.

If you entered

PwxCDCInfo STATUS

, the output shows the overall status of all PowerExchange CDC Publisher processes by using a color indicator and brief description. For example:

PROCESS STATE  GREEN  All processes are running

The other process states are:

YELLOW. A warning condition exists. The data stream might be restricted or not flowing.

RED. The CDC Publisher processes are not running or cannot be found.

If you entered

PwxCDCInfo STATUS DETAIL

, the output shows the status color indicator for each CDC Publisher child process. For example:

PARENT             CHILD      ATTRIBUTE      VALUE  DESCRIPTION  
Extract_Connector  Extract    TRAFFIC LIGHT  GREEN               
Extract_Connector  Formatter  TRAFFIC LIGHT  GREEN               
Extract_Connector  Connector  TRAFFIC LIGHT  GREEN

If you entered

PwxCDCInfo STATUS DETAIL VERBOSE

, the output shows the status color indicator for each CDC Publisher child process with a description of the valid status values. For example:

PARENT             CHILD      ATTRIBUTE      VALUE  DESCRIPTION         
Extract_Connector  Extract    TRAFFIC LIGHT  GREEN  Similar to a traffic light, a red value 
                                                    indicates an error, a green value 
                                                    indicates the process is running as 
                                                    expected, and a yellow value indicates 
                                                    a mixed state (not an error and not 
                                                    running as expected).
Extract_Connector  Formatter  TRAFFIC LIGHT  GREEN  Similar to a traffic light, a red value 
                                                    indicates an error, a green value 
                                                    indicates the process is running as 
                                                    expected, and a yellow value indicates 
                                                    a mixed state (not an error and not 
                                                    running as expected).
Extract_Connector  Connector  TRAFFIC LIGHT  GREEN  Similar to a traffic light, a red value 
                                                    indicates an error, a green value 
                                                    indicates the process is running as 
                                                    expected, and a yellow value indicates 
                                                    a mixed state (not an error and not 
                                                    running as expected).

Rename Saved Search

Table of Contents

User Guide

User Guide

Determining the Status of CDC Publisher Processes

Determining the Status of CDC Publisher Processes