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 LOADPLUS for DB2 13.1.

LOADPLUS DD statements


This topic provides specification guidelines, allocation information, and usage notes for each of the data sets that LOADPLUS uses.

LOADPLUS uses data sets that are specified by ddnames.

Use the following table to quickly find the data set for which you want more information. This table also provides a quick reference to associated command and installation options for each data set type.

Data set type

Reference

Default ddname or prefix

DDTYPE option keyword (DDTYPE)

ddname or prefix installation option

ddname or prefix command option

Command input

SYSIN

Not applicable

Not applicable

Not applicable

Copy

  • BMCCPY (local primary)
  • BMCCPZ (local backup)
  • BMCRCY (remote primary)
  • BMCRCZ (remote backup)
  • LLP (local primary for LOB)
  • LLB (local backup for LOB)
  • LRP (remote primary for LOB)
  • LRB (remote backup for LOB)
  • XLP (local primary for XML)
  • XLB (local backup for XML)
  • XRP (remote primary for XML)
  • XRB (remote backup for XML)
  • LOCPFCPY
  • LOCBFCPY
  • REMPFCPY
  • REMBFCPY
  • LOCPLCPY
  • LOCBLCPY
  • REMPLCPY
  • REMBLCPY
  • LOCPXCPY
  • LOCBXCPY
  • REMPXCPY
  • REMBXCPY

COPYDDN (primary copies) (COPYDDN=(BMCCPY, BMCCPZ))

RCVYDDN (remote copies) (RCVYDDN=(BMCRCY, BMCRCZ))

These options are not available for LOB or XML copy data sets.

COPYDDN (primary copies) (COPYDDN)

RECOVERYDDN (remote copies) (RECOVERYDDN)

These options are not available for LOB or XML copy data sets.

Disable SmartSwitch

BMCSSOFF

Not applicable

Not applicable

Not applicable

Discard

SYSDISC

DISCARD

DISCDDN 1 (DISCDDN=SYSDISC)

DISCARDDN 1 (DISCARDDN)

Error

SYSERR

ERROR

ERRDDN 1 (ERRDDN=SYSERR)

ERRDDN 1 (ERRDDN)

IDCAMS input

SYSIDCIN

Not applicable

IDCDDN (IDCDDN)

Index work

SYSUT1

WORK

WORKDDN 1 (WORKDDN=SYSUT1)

WORKDDN 1 (WORKDDN)

Input

SYSREC

Not applicable

INDDN (INDDN=SYSREC)

INDDN (INDDN)

Load work

SORTOUT

LOAD

LOADDN 1 (LOADDN=SORTOUT)

LOADDN 1 (LOADDN)

Mapping file

SYSMAP

SYSMAP

MAPDDN 1 (MAPDDN=SYSMAP)

MAPDDN 1 (MAPDDN)

Message output

SYSPRINT

Not applicable

Not applicable

Not applicable

Message output

SYSPRIN2

Not applicable

Not applicable

Not applicable

BMC AMI Utilities

NGTSSJCL

Not applicable

Not applicable

Not applicable

BMC AMI Utilities

NGTSSSYN

Not applicable

Not applicable

Not applicable

Other

Not applicable

Not applicable

Not applicable

Not applicable

SNAP dump output for SQLAPPLY load

APTDUMP

Not applicable

Not applicable

Not applicable

Sort message output indicator

UTPRINT

Not applicable

Not applicable

Not applicable

Sort work

SORTWK

SORTWORK

Not applicable

Not applicable

Statistics report output

ASUSRPRT

Not applicable

Not applicable

Not applicable

Thread cancelation report output

BMCFORCE

Not applicable

Not applicable

Not applicable

1 For a DSNUTILB load, LOADPLUS uses these options only to pass a value for the &DDNAME variable of the data set name pattern.

2 Available only if you have installed PTF BQU1423.

3 Available only if you have installed PTF BQU2133.

4 Available only if you have installed PTF BQU2519.

Dynamically allocate data sets

As an alternative to specifying data sets in the DD statements of your JCL, you can have LOADPLUS dynamically allocate the following types of data sets by using the appropriate keyword found in the DDTYPE column above: 

  • SYSREC
  • Copy data sets
  • SORTOUT
  • SORTWK
  • SYSDISC
  • SYSERR
  • SYSMAP
  • SYSUT1

For details about dynamically allocating SYSREC data sets, see INDSN. For details about dynamically allocating the other data sets, see Dynamic-data-set-allocation and Dynamic-allocation-options.

 

 

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