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

REORG PLUS DD statements


REORG PLUS uses data sets specified by ddnames. This section provides specification guidelines, allocation information, and usage notes for each data set that REORG PLUS uses.

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

Data set type

Description reference

Default ddname 1

DDTYPE option keyword

ddname or prefix installation option

ddname or prefix command option

ALTER statement output

DDLOUT

Not applicable

Not applicable

Not applicable

Archive

SYSARC

ARCHIVE

ARCHDDN

ARCHDDN

Command input

SYSIN

Not applicable

Not applicable

Not applicable

Copy, full

  • BCPY (local primary)
  • BCPZ (local backup)
  • BRCY (remote primary)
  • BRCZ (remote backup)
  • LOCPFCPY
  • LOCBFCPY
  • REMPFCPY
  • REMBFCPY
  • COPYDDN (primary copies)
  • RCVYDDN (remote copies)
  • COPYDDN (primary copies)
  • RECOVERYDDN (remote copies)

Copy, incremental

  • BICY (local primary)
  • BICZ (local backup)
  • BIRY (remote primary)
  • BIRZ (remote backup)
  • LOCPICPY
  • LOCBICPY
  • REMPICPY
  • REMBICPY
  • ICDDN
  • RCVICDDN
  • ICDDN
  • RECOVERYICDDN

Disable SmartSwitch

BMCSSOFF

Not applicable

Not applicable

Not applicable

Discard (DSNUTILB only)

SYSARC  2  

ARCHIVE

ARCHDDN  3  

ARCHDDN  3  

Error

SYSERR

Not applicable

Not applicable

Not applicable

REXX exits

SYSEXEC

Not applicable

Not applicable

Not applicable

IDCAMS input

SYSIDCIN

Not applicable

Not applicable

IDCDDN

Index work files

SYSUT1

WORK

WORKDDN 3  

WORKDDN  3  

Input

DDLIN

Not applicable

DDLDDN

DDLDDN

LOAD statements (DSNUTILB only)

SYSPUNCH 2

SYSPUNCH

Not applicable

Not applicable

Message output

SYSTERM

Not applicable

Not applicable

Not applicable

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

REXX statement output

SYSTSPRT

Not applicable

Not applicable

Not applicable

Sort message output indicator

UTPRINT

Not applicable

Not applicable

Not applicable

Sort work files

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

Unload

SYSREC

UNLOAD

UNLDDN 3

UNLDDN  3  

1 This book refers to the data sets by their default ddnames. The name that you use for the data sets will be different if you change them by using the ddname or prefix installation or command options.

2 This value is the default ddname that REORG PLUS passes to the IBM Db2 REORG utility for the &DDNAME variable of the data set name pattern.

3 For a DSNUTILB reorganization, REORG PLUS uses these options only to pass a value for the &DDNAME variable of the data set name pattern.

4  Available only if you have installed PTF BQU1423.

5 Available only if you have installed PTF BQU2133.

6 Available only if you have installed PTF BQU2519.


 

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