Step 3 (DPRSMF)—Db2 performance data tables load procedure
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 |
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. |
ACCADD (BMC.AMIOPS.SPE2304) | If present, contains the accelerator accounting records (ACCA) created from the Db2 SMF 101 accounting records. |
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. |
STATADD (BMC.AMIOPS.SPE2304) | Defines the input data set for the STATA LOAD and SUMMARIZE process |
STATBDD (BMC.AMIOPS.SPE2304) | Defines the input data set for the STATB LOAD and SUMMARIZE process |
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 |
SUMMSTAA (BMC.AMIOPS.SPE2304) | Defines the output data set for the STATA SUMMARIZE process |
SUMMSTAB (BMC.AMIOPS.SPE2304) | Defines the output data set for the STATB 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