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 an SMF Data Set from the PowerExchange Navigator

Viewing Statistics Written to an SMF Data Set from the PowerExchange Navigator

To view SMF statistics that are stored in an SMF 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.
Before you can view SMF statistics in the PowerExchange Navigator, you must extract the SMF data from the system SMF data set and place the data into an intermediate file for viewing.
  1. On the z/OS system, use the SMF SWITCH console command to refresh the collection of SMF statistics.
  2. Run the IBM IFASMFDP utility to extract the SMF records that pertain to PowerExchange. For example, use the following utility SYSIN parameters:
    ) <-Where
    is the LPAR from which to extract data INDD(SYSUT1,OPTIONS(DUMP)) OUTDD(SYSUT2,TYPE(255)) <-Where 255 is the SMF record number in the PWX STATS statement
  3. Stop the PowerExchange Listener on the z/OS system if the Listener is running.
  4. Add the STATS statement with the SMF parameter to the DBMOVER configuration file on the z/OS system. For example:
  5. Start or restart the PowerExchange Listener.
  6. In the PowerExchange Navigator, expand the
    Data Maps
    node in the Resource Explorer and open the pwxstat.file data map.
  7. On the
    Data Map
    tab in the Resource Explorer, right-click the pwxstat.file and click
  8. In the
    Data Map Properties
    dialog box, click the
    SEQ Access Method
  9. In the
    File Name
    field, enter the fully qualified name of the sequential data set to which you extracted SMF data in step 2. Then click
  10. To generate SMF statistics that are available for viewing in the PowerExchange Navigator, stop and restart the PowerExchange Listener on z/OS.
  11. In the PowerExchange Navigator, run a database row test on any table with the suffix "_SMF" in the pwxstat.file data map.
    1. Select the table on the
      Data Map
      tab, and then select
      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 PowerExchange statistics that were collected from the SMF data set.


We’d like to hear from you!