Syntax

PWXCDCINFO 
[INSTANCE=
override_instance_directory]
[STATS={TOPIC|INTERNAL [VERBOSE]}[RESET]
[STATUS [DETAIL [VERBOSE]]

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

STATS={TOPIC|INTERNAL [VERBOSE]} [RESET]}

Reports information about the topics that the CDC Publisher has updated or internal statistics and state information for PowerExchange CDC Publisher child processes (Extract, Formatter, and Connector). The statistics are cumulative since the Publisher process started. You can use the optional RESET parameter to refresh the topic information or reset the statistics counters to their original values.

Do not specify both the TOPIC and INTERNAL parameters.

You can enter the STATS parameter in any of following ways:

STATS=TOPIC
. Reports the following information for each topic that the CDC Publisher updated:
Updated topic name and partition ID
Number of messages sent to the topic
Partition offset returned
Source table name
Last change operation type and sequence ID
STATS=TOPIC RESET
. Clears the statistics for the updated topics.
STATS=INTERNAL
. Reports detailed statistics and state information, by internal attribute, for each type of PowerExchange CDC Publisher child process. This information is primarily for diagnostic use by Informatica Global Customer Support and other technical staff. The following example shows the report format:
PARENT    CHILD                        ATTRIBUTE          VALUE      DESCRIPTION
Extract   Extract Capture Consumer     InputRecordsRead   2018                                                                            
Extract   Extract Capture Consumer     InputBytesRead     12560180
STATS=INTERNAL VERBOSE
. Reports detailed statistics and state information, by internal attribute, for each of the major PowerExchange CDC Publisher internal processes with a description of the attribute. The following example shows the verbose report format:
PARENT    CHILD                        ATTRIBUTE          VALUE      DESCRIPTION
Extract   Extract Capture Consumer     InputRecordsRead   2018       The current number of input records consumed by this process.
Extract   Extract Capture Consumer     InputBytesRead     12560180   The current number of bytes of input consumed by this process.
Do not specify INTERNAL VERBOSE with the RESET parameter.
STATS=INTERNAL RESET
. Resets the internal attribute values to their initial values at CDC Publisher startup.

STATUS [DETAIL [VERBOSE]]

Indicates the status of the PwxCDCPublisher processes.

You can enter the STATUS parameter in any of following ways:

STATUS
. Reports 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
Other process states are: YELLOW for a warning situation, or RED for a CDC Publisher subprocess that stopped or could not be found. If the main CDC Publisher process terminates or is unavailable for connection, error messages are reported instead of a process state.
STATUS DETAIL
. Reports the status color indicator for each of the major PowerExchange CDC Publisher internal processes, including the Extract, Filter, Formatter, and Connector processes. The following example shows the status of the Extract internal process:
PARENT              CHILD      ATTRIBUTE        VALUE     DESCRIPTION         
Extract_Connector   Extract    TRAFFIC LIGHT    GREEN
STATUS DETAIL VERBOSE
. Reports the status color indicator and a brief description of the status for each of the major PowerExchange CDC Publisher internal processes.The following example shows the verbose status information for the Extract internal process:
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).
VERBOSE can be specified only with the DETAIL parameter.