Reference Manual

10.5
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

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

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.

On the z/OS system, stop the PowerExchange Listener.

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)

Start the PowerExchange Listener again.

In the PowerExchange Navigator, expand the

Data Maps

node in the Resource Explorer and open the pwxstat.file data map.

On the

Data Map

tab in the

Resource Explorer

, right-click the pwxstat.file and click

Properties

In the

Data Map Properties

dialog box, click the

SEQ Access Method

tab.

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

To generate PowerExchange statistics that will be available for viewing from the PowerExchange Navigator, stop and restart the PowerExchange Listener on z/OS.

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.

Select the table on the

Data Map

tab, and then click

File

Database Row Test

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

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

Click

The

Database Row Test Output

window displays the SMF statistics that were written to the PowerExchange file.

SMF Statistics Logging and Reporting

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Reference Manual

Reference Manual

Viewing Statistics Written to a PowerExchange File from the PowerExchange Navigator

Viewing Statistics Written to a PowerExchange File from the PowerExchange Navigator