Step 4 (DPRSMF)—Load into Db2 tables

This step specifies the name of the Db2 Utility program and the region that is required to run the program.

The steps to load the Db2 tables use one of the following utilities:

  • DSNUTILB (IBM LOAD method)
  • NGTUTIL (BMC AMI Load for Db2 method)

Related topic

DPRSMF-job-control-statements


Important

  • BMC AMI Load for Db2 (BMC AMI Load) is the preferred BMC table load utility. If your installation uses the IBM LOAD utility, you must modify your JCL. The utility must be able to interpret LOAD control statements in the same format that DSNUTILB uses.
  • You can replace the procedure symbolic LOADPGM with IEFBR14 to disable this step.

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

DD statement

Description

ACBUFDD DD

(Optional)

Defines the input data set for the BUFACCT data for the LOAD utility

If this statement is not present, the ACCTDD input data set is used.

ACCTDD DD

Defines the input data set for ACCT data for the LOAD utility

Optionally, defines the input data set for the PKGACCT, DDFACCT, and BUFACCT data for the LOAD utility.

If present, contains the accelerator accounting records (ACCA) created from the Db2 SMF 101 accounting records.

ACDDFDD DD

(Optional)

Defines the input data set for the DDFACCT data for the LOAD utility

If this statement is not present, the ACCTDD input data set is used.

ACPKGDD DD

(Optional)

Defines the input data set for the PKGACCT data for the LOAD utility

If this statement is not present, the ACCTDD input data set is used.

AUDITDD DD

Defines the input data set for the AUDIT LOAD utility

BUFSACCT DD

Defines the input data set containing Buffer Summary data, for the BUFACCT SUMMARIZE LOAD utility

BUFSSTAT DD

Defines the input data set for the BUFSTAT SUMMARIZE LOAD utility

CDBCKPT DD

Defines the data set containing checkpoint/restart information

CDBEXEC DD

Defines automation support

DDFSACCT DD

Defines the input data set for the DDFACCT SUMMARIZE LOAD utility

DDFSSTAT DD

Defines the input data set for the DDFSTAT SUMMARIZE LOAD utility

DPDDGBP DD

Defines the input data set for the dynamic and group buffer pool attribute data for the LOAD utility

PKGSACCT DD

Defines the input data set for the PKGACCT SUMMARIZE LOAD utility

SORTOUT DD

Defines the data set for the SORT output

STATDD DD

Defines the input data set for the STAT LOAD utility

Defines the input data set for the STATA LOAD and SUMMARIZE process

Defines the input data set for the STATB LOAD and SUMMARIZE process

STEPLIB DD

Defines the program library containing the Db2 load library

SUMMACCT DD

Defines the input data set for the ACCT SUMMARIZE LOAD utility

SUMMSTAT DD

Defines the input data set for the STAT SUMMARIZE LOAD utility

Defines the output data set for the STATA SUMMARIZE process

SUMMSTAB    (BMC.AMIOPS.SPE2304)  

Defines the output data set for the STATB SUMMARIZE process

SYSIN DD

Defines the input data set containing the Db2 LOAD control statement

SYSPRINT DD

Defines the data set for program messages

SYSUDUMP DD

Defines the dump data set for problem determination

UTLPARMS DD

Defines global parameters that can override installation options

UTPRINT DD

Defines the data set for DFSORT messages

xxxPARMS

Defines specific utility parameters that can override installation options

 

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