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.