Bulk Data Movement Guide

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

Back Next

Read Progress Messages

You can configure PowerExchange to issue PWX-04587 messages to report read progress.

To direct PowerExchange to write read progress messages, include the following parameters in the DBMOVER configuration file:

PRGIND.
Specify Y to have PowerExchange write PWX-04587 messages that indicate the number of records read for a bulk data movement session. Default is N.

PRGINT.
Specify the number of records that PowerExchange reads before writing the PWX-04587 messages to the PowerExchange log file. Default is 250 records.

The PWX-04587 messages have the following format:

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

Where:

int_server
is the name of the PowerCenter Integration Service.

workflow_name
is the name of the workflow that contains the bulk data movement session.

session_name
is the name of the bulk data movement session.

num_records
is the cumulative number of records read since the bulk data movement session started.

For example, to direct PowerExchange to write read progress messages after 100 records, the DBMOVER configuration file contains the following statements:

PRGIND=Y
PRGINT=100

When a bulk data movement session that has a session name of s_DB2_SQL_stats runs, PowerExchange writes the following messages to the PowerExchange log file:

PWX-04587 intserv/wf_blk_mon_stats/s_DB2_SQL_stats: Records read=100
PWX-04587 intserv/wf_blk_mon_stats/s_DB2_SQL_stats: Records read=200
PWX-04587 intserv/wf_blk_mon_stats/s_DB2_SQL_stats: Records read=300

PowerExchange continues to write PWX-04587 messages for this bulk data movement session until the session ends. In the PowerExchange log file, each of these messages has a date and time stamp. You can use this information to determine the rate at which PowerExchange processes bulk data on the source system.

For nonrelational bulk data movement sources, include the PRGIND and PRGINT statements in the DBMOVER configuration file on the PowerExchange Listener machine. For relational bulk data movement sources, include the PRGIND and PRGINT statements in the DBMOVER configuration file on the PowerCenter Integration Service machine.

For DB2 relational connections, PowerExchange writes a PWX-04587 message after it reads the following number of records:

The smallest multiple of the Array Size
connection attribute that is greater than or equal to the value of PRGINT

Because the PRGIND and PRGINT statements apply to every workflow that runs on the Integration Service machine and connects to the PowerExchange Listener, Informatica recommends that you use these statements judiciously.

Rename Saved Search

Table of Contents

Bulk Data Movement Guide

Bulk Data Movement Guide

Read Progress Messages

Read Progress Messages