Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange Bulk Data Movement
  3. PowerExchange Listener
  4. Adabas Bulk Data Movement
  5. Datacom Bulk Data Movement
  6. DB2 for i5/OS Bulk Data Movement
  7. DB2 for Linux, UNIX, and Windows Bulk Data Movement
  8. DB2 for z/OS Bulk Data Movement
  9. IDMS Bulk Data Movement
  10. IMS Bulk Data Movement
  11. Microsoft SQL Server Bulk Data Movement
  12. Oracle Bulk Data Movement
  13. Sequential File Bulk Data Movement
  14. VSAM Bulk Data Movement
  15. Writing Data with Fault Tolerance
  16. Monitoring and Tuning Options

Bulk Data Movement Guide

Bulk Data Movement Guide

Monitoring Bulk Data Movement Sessions in PowerExchange

Monitoring Bulk Data Movement Sessions in PowerExchange

In PowerExchange, you can use the following methods to monitor data extraction by bulk data movement sessions:
  • Read progress messages.
    You can request that PowerExchange write messages that indicate the number of data records read by a bulk data movement session.
  • Bulk data movement statistics messages.
    When bulk data movement sessions end, PowerExchange writes messages that include statistical information about the quantity of data records processed.
  • Multithreaded processing statistics messages.
    You can request that PowerExchange write statistical information about bulk data movement sessions that use multithreaded processing.
  • LISTTASK command output.
    You can use the LISTTASK command to display active bulk data movement sessions.
  • DISPLAYSTATS command output.
    You can use the DISPLAYSTATS command to publish monitoring statistics for a PowerExchange Listener that runs on Linux, zLinux, UNIX, Windows, or z/OS.
PowerExchange writes read progress messages, bulk data movement statistics messages, and multithreaded processing statistics messages to the PowerExchange log file. You can also configure PWXPC to write these and other PowerExchange informational messages to the PowerCenter session log.
By default, PWXPC writes error and warning messages but not informational messages to the session log. To configure PWXPC to write PowerExchange informational messages to the session log, define one of the following connection attributes or options:
  • Select the
    Retrieve PWX Log Entries
    connection attribute. (PWXPC application connection types only)
  • Add the RETLOGINFOMSG=Y option in the
    PWX Override
    connection attribute. (All PWXPC connection types)
The
Retrieve PWX Log Entries
connection attribute and the RETLOGINFOMSG=Y option of the
PWX Override
connection attribute are equivalent.

0 COMMENTS

We’d like to hear from you!