Table of Contents


  1. Preface
  2. Introduction to PowerExchange
  3. DBMOVER Configuration File
  4. Netport Jobs
  5. PowerExchange Message Logs and Destination Overrides
  6. SMF Statistics Logging and Reporting
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. DTLDESCRIBE Metadata
  12. PowerExchange Globalization
  13. Using the PowerExchange ODBC Drivers
  14. PowerExchange Datatypes and Conversion Matrix
  15. Appendix A: DTL__CAPXTIMESTAMP Time Stamps
  16. Appendix B: PowerExchange Glossary

SMF Statistics Logging and Reporting Overview

SMF Statistics Logging and Reporting Overview

PowerExchange can use the IBM System Management Facilities (SMF) to log statistics records for monitoring PowerExchange activity and performance.
The PowerExchange Listner produces the following types of SMF statistics records:
  • Connection record, driven by the PowerExchange Listener
  • Start record, driven by a PowerExchange process, netport job, PowerExchange Listener, or subtask
  • End record, for all processes including those that ended abnormally
  • Interval statistics record, for all processes
These records report the following information:
  • Record header and section descriptor information
  • SMF triplet information
  • General information, including the PowerExchange version and build, component name, process name and ID, node name, client session information, map name, return codes, CPU time, length of extended section descriptors, and zIIP times
  • PowerExchange Listener statistics, including the Listener job or task name, node name, IP address, starting and ending times, port number, number of connections, CPU time, number of bytes and messages sent, and number of bytes and messages received
  • PowerExchange client statistics, including the start and end times, CPU time, number of bytes and messages sent, number of bytes and messages received, and return codes
  • Access-method statistics, including the access method type, number of rows and bytes read, and number of rows and bytes written
  • DB2 for z/OS function and access-method statistics, including the CPU time, number of DB2 statements executed, number of rows returned, DB2 SSID, DB2 plan name, connection type, authorization ID, correlation ID, and number of rows by DML change type
To log SMF statistics records to SMF data sets, you must specify the STATS statement with the SMF parameter and a record type in the DBMOVER configuration file. Consult with your system programmer or capacity planning team to determine the SMF record type to use. The record type can be in the range of 128 through 255.
Alternatively, for testing purposes, you can log statistics records to a sequential data set on z/OS. To log statistics to a sequential data set, specify the STATS statement with the FILE parameter. The FILE parameter must specify a pre-allocated data set.
In both logging scenarios, you can optionally specify an interval at which to log statistics records. The records then show cumulative statistics for all tasks that are active at the time the statistics are generated. You can use these statistics to monitor the activity and progress of long-running tasks and to compare activity over multiple interval-reporting periods. Interval logging does not report the following information:
  • Activity by tasks that started and completed between two interval reports
  • Activity by tasks that ended since the last interval report
After you log SMF statistics, you can view them from the PowerExchange Navigator. If you logged SMF statistics to SMF archived data sets, you also can generate reports based on the SMF record type. To generate reports, use the DTLSMFRP program that PowerExchange provides.


We’d like to hear from you!