Step 2 (DPRSMFA)—Statistics consolidation

This step specifies the name of the Performance Reporter statistics consolidation program as PGM=DPRSTAT and the region required to run the program.F

The following table describes the DD statements that are used in this step:

Related topic

DPRSMF-job-control-statements


DD Statement

Description

STEPLIB DD

Defines the program library containing the DPRSTAT load module

DPRLOG DD

Defines the data set for DPRSTAT results

SYSOUT DD

Defines the output class

SYSUDUMP DD

Defines the dump data set for problem determination

SORTIN DD

Defines the statistics record file (input file) passed from Step 1

DPDSPIN DD

Defines a spin file to retain SMF statistics records that end a period to resolve intervals on subsequent SMF processing

The spin file is useful only when the same input source (such as an SMF Generation Data Group or Data Collector archive) is used for each DPRSMF run. When the DPRSMF job runs, information from the last SMF statistics record encountered for each Db2 subsystem is written to the spin file and then used as the first record for the next DPRSMF run. The DPRSMF job must run at regular intervals to ensure that no intervals are lost.

If DPRSMF does not run at regular intervals, allocate a new spin file for each run. DMRSMF allocates the spin file with DISP=OLD. To create a new spin file, use the BBSAMP sample JCL member DPJSPIN.

DPDSTAT DD

Defines the final statistics record file ready to be loaded to Db2 tables (output file)

This file is passed to Step 4 STATDD and to Step 5 DPDSTAT

Where to go from here

See Step-3-DPRSMFA-Job-submission-for-parallel-processing


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*