Default language.

Space announcement The Using section of the MainView for DB2 documentation is now available in Japanese. The displayed language is dependent on your browser language. You can switch languages from the Language menu.

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 (NGT Load method)
  • AMUUMAIN (LOADPLUS method)

Note

Next Generation Technology Load for Db2 for z/OS (NGT Load) is the preferred BMC table load utility. Future releases of MainView for DB2 will not support LOADPLUS for Db2.

If your installation uses a different 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

SYSDISC DD

(for the BMC LOADPLUS method only)

Required for LOADPLUS processing, but not used

SYSERR DD

(for the BMC LOADPLUS method only)

LOADPLUS work data set, containing records with conversion errors

SYSIN DD

Defines the input data set containing the DB2 LOAD control statement

SYSPRINT DD

Defines the data set for program messages

SYSREC DD

(for the BMC LOADPLUS method only)

Defines the input data set, consisting of a concatenation of all the data to be loaded

SYSUDUMP DD

Defines the dump data set for problem determination

SYSUT1 DD

(for the BMC LOADPLUS method only)

LOADPLUS work data set

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*