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 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

PowerExchange_installation
\examples\datamaps

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.

On the z/OS system, use the SMF SWITCH console command to refresh the collection of SMF statistics.

Run the IBM IFASMFDP utility to extract the SMF records that pertain to PowerExchange. For example, use the following utility SYSIN parameters:

SID(xxxx)               <-Where xxxx 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

Stop the PowerExchange Listener on the z/OS system if the Listener is running.

Add the STATS statement with the SMF parameter to the DBMOVER configuration file on the z/OS system. For example:

STATS=(SMF,255,0)

Start or restart the PowerExchange Listener.

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 fully qualified name of the sequential data set to which you extracted SMF data in step 2. Then click

To generate SMF statistics that are available for viewing in the PowerExchange Navigator, stop and restart the PowerExchange Listener on z/OS.

In the PowerExchange Navigator, run a database row test on any table with the suffix "_SMF" in the pwxstat.file data map.

Select the table on the

Data Map

tab, and then select

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 PowerExchange statistics that were collected from the SMF data set.

Rename Saved Search

Table of Contents

Reference Manual

Reference Manual

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

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