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

Assessing the Performance of Partitioned Bulk Data Movement Sessions

Use the SHOW_THREAD_PERF statement in the dbmover.cfg file to print messages that contain statistics for assessing the performance of partitioned bulk data movement sessions at user-defined intervals. The messages pertain to sessions with reader or writer partitions.

Enter the SHOW_THREAD_PERF statement in the dbmover.cfg configuration file on the PowerCenter Integration Service machine. The statement defines the number of records that PowerExchange must process before writing statistics messages PWX-31261 and PWX-31262 to the PowerExchange message log. If you specify the

Retrieve PWX Log Entries

attribute on the connection, PWXPC writes these messages in the PowerCenter session log too.

The messages provide the following information:

PWX-31261. Average, minimum, and maximum amounts of time, in microseconds, that the joiner thread spent performing I/O over a specific number of records.

PWX-31262. Average, minimum, and maximum

I/O

delay times, in microseconds, for a partition over a specific number of records. The delay time is the time that the partition waits to receive data. This message is issued for each partition in a session.

Rename Saved Search

Table of Contents

Bulk Data Movement Guide

Bulk Data Movement Guide

Assessing the Performance of Partitioned Bulk Data Movement Sessions

Assessing the Performance of Partitioned Bulk Data Movement Sessions