English
  • PowerExchange for CDC and Mainframe 10.4.0
  • All Products

Table of Contents

Search

  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. PowerExchange Globalization
  12. Using the PowerExchange ODBC Drivers
  13. PowerExchange Datatypes and Conversion Matrix
  14. Appendix A: DTL__CAPXTIMESTAMP Time Stamps
  15. Appendix B: PowerExchange Glossary

Reference Manual

Reference Manual

Back Next

STATS Statement

STATS Statement

The STATS statement controls whether PowerExchange writes SMF statistics records for the PowerExchange Listener to the z/OS System Management Facilities (SMF) or to a file. This statement also controls whether PowerExchange collects summary monitoring statistics on PowerExchange Listener resource usage and client requests and reports these statistics at a regular interval or only on demand.
SMF statistics are available for PowerExchange Listeners on z/OS. The PowerExchange Listener summary monitoring statistics are available for PowerExchange Listeners on i5/OS, Linux, UNIX, Windows, and z/OS.
i5/OS, Linux, UNIX, Windows, and z/OS
No 
STATS=({SMF,
record_number
[,{
interval
|
0
}]  |
        FILE,
dataset_name
[,{
interval
|
0
}]  |
        MONITOR[,{
interval
|
0
}]  |
        
NONE
}
)
SMF,
record_number
[,{
interval
|
0
}]
PowerExchange writes SMF statistics records to SMF.
Enter the following parameters:
record_number
Required. An SMF record number.
Valid values are 128 through 255.
{
interval
|
0
}
Optional. The interval, in minutes, after which PowerExchange writes an SMF record.
Valid values are 0 through 120. Default is 0, which disables interval processing. With the default, PowerExchange writes an SMF record at the end of a task or when the PowerExchange Listener shuts down.
FILE,
dataset_name
[,{
interval
|
0
}]
PowerExchange writes SMF statistics records to a sequential data set on z/OS.
Enter the following parameters:
dataset_name
Required. Name of the sequential data set to which PowerExchange writes SMF records. You must have pre-allocated the data set. Ensure that the data set is large enough to accommodate the SMF record sizes. For variable length, blocked data sets, the following DCB allocation attributes are usually sufficient: LRECL=5000 and BLKSIZE=27998.
{
interval
|
0
}
Optional. Interval, in minutes, after which PowerExchange writes an SMF record to the data set.
Valid values are 0 through 120. Default is 0, which disables interval processing. With the default, PowerExchange writes an SMF record when the PowerExchange Listener shuts down.
MONITOR[,{
interval
|
0
}]
PowerExchange collects summary statistics on PowerExchange Listener memory usage, CPU usage, client tasks, connections, data sent and received, and messages sent and received. These listener statistics are published to the system console or PowerExchange message log when you enter a DISPLAYSTATS or DISPLAYSTATS LISTENER command either locally from the command line or remotely with the pwxcmd program. If you configured a PowerExchange Listener Service in the Informatica domain, you can use the infacmd pwx displayStatsListener command to publish these statistics.
For a PowerExchange Listener on i5/OS, you must use the pwxcmd displaystats command. You cannot enter the DISPLAYSTATS or DISPLAYSTATS LISTENER command from the i5/OS command line or use the infacmd pwx displayStatsListener command.
Optionally, for a PowerExchange Listener on any supported operating system, you can specify the following
interval
 subparameter to publish the statistics at a regular interval:
{
interval
|
0
}
Optional. The interval, in minutes, after which PowerExchange publishes the PowerExchange Listener summary statistics. You can still use the DISPLAYSTATS, DISPLAYSTATS LISTENER, pwxcmd displaystats, or infacmd pwx displayStatsListener command to publish the statistics on demand.
Valid values are 0 through 120. Default is 0, which disables interval-based reporting of PowerExchange Listener summary statistics. With the default, PowerExchange writes these statistics only when a DISPLAYSTATS, pwxcmd displaystats, or infacmd pwx displayStatsListener command is issued.
NONE
PowerExchange does not write SMF records and does not collect PowerExchange Listener summary statistics.
Default is NONE.
  • If you want to use the DISPLAYSTATS, DISPLATSTATS LISTENER, or infacmd pwx displayStatsListener command to publish PowerExchange Listener summary statistics, you must include the MONITOR parameter in the STATS statement. For more information about the commands, see the
    PowerExchange Command Reference
     and
    Informatica Command Reference
    .
  • To write records to SMF, you must APF-authorize all libraries in the STEPLIB concatentation of the PowerExchange Listener.
  • Write PowerExchange SMF records to a file for test purposes or when you need to get some SMF statistics quickly. For long-term statistics collection, write PowerExchange SMF records to SMF.
  • PowerExchange ships a data map, called pwxstat.file.dmp, with the Windows version of PowerExchange that you can use with PowerExchange Navigator to format the SMF records written to a file.