.
Step 2 (DPRSMF)—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.
The following table describes the DD statements that are used in this step:
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 |
SORTWKnn DD | Defines work data sets for data sorting; nn is a numeric |
Where to go from here
See Step 3—DB2 performance data tables load procedure
Related topic