Reference Manual

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

Back Next

SHOW_THREAD_PERF Statement

The SHOW_THREAD_PERF statement specifies the number of records that PowerExchange processes before writing statistics messages for sessions that use multithreaded processing or partitioned processing to the PowerExchange message log file or PowerCenter session log.

All

All CDC sources. For bulk data movement sessions, the following sources: DB2 for z/OS tables, sequential and flat files, and VSAM data sets.

For bulk data movement sessions that use writer partitions, the following targets: VSAM data sets and sequential files.

SHOW_THREAD_PERF=number_of_records

For the number_of_records variable, enter the number of records that PowerExchange must process in a statistics reporting interval before writing messages with statistics that you can use to assess session performance. Valid values are 10000 through 50000000.

For sessions that use multithreading, PowerExchange writes messages PWX-31254 through PWX-31259 to the PowerExchange message log file. For bulk data movement sessions that use reader or writer partitioning, PWXPC writes messages PWX-31261 and PWX-31262 in the PowerCenter session log and PowerExchange message log.

To have PWXPC write statistics messages in the PowerCenter session log, select the

Retrieve PWX log entries

attribute on a PWX CDC application connection or PWX Batch application connection. This attribute is selected by default.

Rename Saved Search

Table of Contents

Reference Manual

Reference Manual

SHOW_THREAD_PERF Statement

SHOW_THREAD_PERF Statement