CDC Guide for Linux, UNIX, and Windows

10.4.0 HotFix 1
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0

Back Next

Read Progress Messages

You can request that PowerExchange write read progress messages to the PowerExchange message log file. These messages indicate the number of change records read for a CDC session.

If you select the

Retrieve PWX log entries

option on the PWX CDC application connection, PWXPC also writes these messages in the session log.

To have PowerExchange write read progress messages, include the following statements in the DBMOVER configuration file:

PRGIND=Y: Enter Y to have PowerExchange write PWX-04587 messages to the PowerExchange message log file. These messages indicate the number of records read for a CDC session. Default is N.
PRGINT=records: Enter the number of records that PowerExchange must read before writing PWX-04587 messages to the PowerExchange message log file. Default is 250 records.

For example, to have PowerExchange write read progress messages after reading 100 records, specify the following statements:

PRGIND=Y
PRGINT=100

PWX-04587 messages have the following format:

PWX-04587 int_server/workflow_name/session_name: Records read=records

Where:

int_server is the name of the PowerCenter Integration Service.

workflow_name is the name of the workflow that contains the CDC session.

session_name is the name of the CDC session.

records is the cumulative number of records read since the CDC session started.

For example, for a CDC session named s_cdc_DB2_SQL_stats runs, PowerExchange writes the following messages:

PWX-04587 intserv/wf_cdc_mon_stats/s_cdc_DB2_SQL_stats: Records read=100

PWX-04587 intserv/wf_cdc_mon_stats/s_cdc_DB2_SQL_stats: Records read=200

PWX-04587 intserv/wf_cdc_mon_stats/s_cdc_DB2_SQL_stats: Records read=300

PowerExchange continues to write PWX-04587 messages for this CDC session until the session ends. In the PowerExchange message log file, each of these messages has a date and time stamp. Use this information to determine the speed with which PowerExchange processes change data from the change stream.

Monitoring CDC Sessions in PowerExchange

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal