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)
- AMUUMAIN (BMC LOADPLUS utility)
- NGTUTIL (NGT Load utility)
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.
The following table describes the DD statements used in this step.
JCL Statement | Description |
|---|---|
ACBUFDD DD | Defines the input data set for the BUFACCT LOAD and SUMMARIZE processes |
ACCELDD DD | Defines the input data set for the ACCA LOAD and SUMMARIZE processes |
ACCTDD DD | Defines the input data set for the ACCT LOAD and SUMMARIZE processes |
ACDDFDD DD | Defines the input data set for the DDFACCT LOAD and SUMMARIZE processes |
AUDITDD DD | Defines the input data set for the AUDIT LOAD utility |
ACPKGDD DD | Defines the input data set for the PKGACCT LOAD and SUMMARIZE processes |
BUFSACCT DD | Defines the input data set for the BUFACCT SUMMARIZE LOAD utility |
BUFSSTAT DD | Defines the input data set for the BUFSTAT SUMMARIZE LOAD utility |
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 |
PKGSACCT DD | Defines the input data set for the PKGACCT SUMMARIZE LOAD utility |
SORTOUT DD | Defines the data set for the SORT output |
STEPLIB DD | Defines the program library containing the DB2 Utility load program |
SUMMACCA | Defines the output data set for the SUMMARIZE process. This file is passed to Step 4. |
SUMMACCS | Defines the output data set for the ACCS SUMMARIZE process |
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 |
SUMMSYMB | Defines the output data set for the SYMB SUMMARIZE process. This file is passed to Step 4. |
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 utility control statement |
SYSPRINT | 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 |
UTPRINT DD | Defines the data set for DFSORT messages |
JCL Statement | Description |
|---|---|
ACBUFDD DD | Defines the input data set for the BUFACCT LOAD and SUMMARIZE processes |
ACCELDD DD | Defines the input data set for the ACCA LOAD and SUMMARIZE processes |
ACCTDD DD | Defines the input data set for the ACCT LOAD and SUMMARIZE processes |
ACDDFDD DD | Defines the input data set for the DDFACCT LOAD and SUMMARIZE processes |
AUDITDD DD | Defines the input data set for the AUDIT LOAD utility |
ACPKGDD DD | Defines the input data set for the PKGACCT LOAD and SUMMARIZE processes |
BUFSACCT DD | Defines the input data set for the BUFACCT SUMMARIZE LOAD utility |
BUFSSTAT DD | Defines the input data set for the BUFSTAT SUMMARIZE LOAD utility |
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 |
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 |
STEPLIB DD | Defines the program library containing the DB2 Utility load program |
SUMMACCA | Defines the output data set for the SUMMARIZE process. This file is passed to Step 4. |
SUMMACCS | Defines the output data set for the ACCS SUMMARIZE process |
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 |
SUMMSYMB | Defines the output data set for the SYMB SUMMARIZE process. This file is passed to Step 4. |
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 utility control statement |
SYSPRINT | 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 |
UTPRINT DD | Defines the data set for DFSORT messages |
Related topic