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
  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. DTL__CAPXTIMESTAMP Time Stamps
  15. PowerExchange Glossary

Viewing Statistics Written to a PowerExchange File

Viewing Statistics Written to a PowerExchange File

You must use the sample pwxstat.file data map that has the same release level as the current PowerExchange Listener to view statistics that have been written to a PowerExchange sequential data set on z/OS. Otherwise, inconsistent results might occur.
The pwxstat.file.dmp data map file is located in the
PowerExchange_installation
\examples\datamaps
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:
    STATS=(FILE,DTLUSR.V800.PWXFILE,0)
  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
    Properties
    .
  6. In the
    Data Map Properties
    dialog box, click the
    SEQ Access Method
    tab.
  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
    OK
    .
  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
      File
      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
      Yes
      . Then in the
      Data Map Remote Node
      dialog box, enter connection information for the remote z/OS location and click
      OK
      .
    3. In the
      Database Row Test
      dialog box, ensure that the following settings are specified:
      • In the
        DB Type
        list, select
        NRDB
        .
      • In the
        Location
        list, select the z/OS node name.
      • In the
        Fetch
        list, select
        Data
        .
    4. Click
      Go
      .
      The
      Database Row Test Output
      window displays the PowerExchange statistics that were collected from SMF.