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

Viewing Statistics Written to a PowerExchange File from the PowerExchange Navigator

Viewing Statistics Written to a PowerExchange File from the PowerExchange Navigator

To view SMF statistics that were written to a PowerExchange sequential data set on z/OS from the PowerExchange Navigator, you must use the sample pwxstat.file data map that has the same release level as the current PowerExchange Listener. Otherwise, inconsistent results might occur.
The pwxstat.file.dmp data map file is located in the
directory on the PowerExchange Navigator system. Do not edit this file.
If you write statistics directly to a sequential data set or GDG, PowerExchange operational problems might occur.
  1. On the z/OS system, stop the PowerExchange Listener.
  2. In the DBMOVER configuration file on the z/OS system, add a STATS statement that includes the FILE parameter. In the FILE parameter, specify the fully qualified name of the sequential data set to which to write statistics. For example:
  3. Start the PowerExchange Listener again.
  4. In the PowerExchange Navigator, expand the
    Data Maps
    node in the Resource Explorer and open the pwxstat.file data map.
  5. On the
    Data Map
    tab in the
    Resource Explorer
    , right-click the pwxstat.file and click
  6. In the
    Data Map Properties
    dialog box, click the
    SEQ Access Method
  7. In the
    File Name
    field, enter the name of the sequential data set that you specified in the STATS statement in the DBMOVER configuration file in step 2. Then click
  8. To generate PowerExchange statistics that will be available for viewing from the PowerExchange Navigator, stop and restart the PowerExchange Listener on z/OS.
  9. In the PowerExchange Navigator, run a database row test on any table in the pwxstat.file data map that does NOT have the "_SMF" suffix.
    1. Select the table on the
      Data Map
      tab, and then click
      Database Row Test
    2. If the data map has not been previously saved to the z/OS system, the PowerExchange Navigator displays a message prompt that asks if you want to send the data map to the remote location. Click
      . Then in the
      Data Map Remote Node
      dialog box, enter connection information for the remote z/OS location and click
    3. In the
      Database Row Test
      dialog box, ensure that the following settings are specified:
      • In the
        DB Type
        list, select
      • In the
        list, select the z/OS node name.
      • In the
        list, select
    4. Click
      Database Row Test Output
      window displays the SMF statistics that were written to the PowerExchange file.


We’d like to hear from you!