.
Step 3 (DPRSMF)—Db2 performance data tables load procedure
This step specifies the name of the Performance Reporter summary load control program as PGM=DPSUMLD.
The following table describes the DD statements that are used in this step:
DD Statement | Description |
|---|---|
STEPLIB DD | Defines the program library containing the Db2 load library and the Performance Reporter load library |
DPSYSOUT DD | Defines the data set for DPSUMLD results |
SYSOUT DD | Defines the output class |
SYSUDUMP DD | Defines the dump data set for problem determination |
SORTWKnn DD | Defines work data sets for data sorting; nn is a numeric |
ACCTDD DD | Defines the input data set for the ACCT LOAD and SUMMARIZE process Optionally, defines the input data set for the PKGACCT, DDFACCT, and BUFACCT LOAD and SUMMARIZE processes if separate data sets were not used in Step 1. |
STATDD DD | Defines the input data set for the STAT LOAD and SUMMARIZE process Optionally, defines the input data set for the DDFACCT and BUFACCT LOAD and SUMMARIZE processes. |
ACPKGDD DD (Optional ) | Defines the input data set for the PKGACCT LOAD and SUMMARIZE process If this statement is not present, the ACCTDD input data set is used. |
ACDDFDD DD (Optional ) | Defines the input data set for the DDFACCT LOAD and SUMMARIZE process If this statement is not present, the ACCTDD input data set is used. |
ACBUFDD DD (Optional ) | Defines the input data set for the BUFACCT LOAD and SUMMARIZE process If this statement is not present, the ACCTDD input data set is used. |
SUMACCT DD | Defines the output data set for the ACCT SUMMARIZE process |
DDFSACCT DD | Defines the output data set for the DDFACCT SUMMARIZE process |
PKGSACCT DD | Defines the output data set for the package PKGACCT SUMMARIZE process |
BUFSACCT DD | Defines the output data set for the Buffer Pool BUFACCT SUMMARIZE process |
SUMMSTAT DD | Defines the output data set for the STAT SUMMARIZE process |
DDFSSTAT DD | Defines the output data set for the DDFSTAT SUMMARIZE process |
BUFSSTAT DD | Defines the output data set for the BUFSTAT SUMMARIZE process |
DPLOAD DD | Defines the data set for Db2 LOAD control statements |
DPSYSIN DD | Defines the data set containing the control statements for the DPSUMLD program For more information, see DPSUMLD-control-statements. |
Where to go from here
Related topic