Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Ops Monitor for Db2 13.1 image-2024-5-19_8-5-1.png .

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)

Note

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.

Note

The procedure symbolic LOADPGM can be changed to 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.

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

SORTWKnn DD

Defines work data sets for data sorting; nn is a numeric

STATDD DD

Defines the input data set for the STAT LOAD utility

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

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

Related topic

DPRSMF-job-control-statements


 

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