Skip to Content

Default language.

Information
Limited support BMC 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 Reorg for Db2 13.1.

Producing image copies

For efficiency, BMC AMI Reorg might initiate an extra copy server. This server job functions solely to produce image copies from objects that have been already reorganized and completed.

In addition to the syntax options described in REORG-TABLESPACE-syntax-diagrams, you can use the following controls.

Warning

Important

BMC AMI Reorg supports only dynamic allocation of copy data sets. If you specify copy DD statements in your JCL, BMC AMI Reorg ignores them.

Global parameters

The following global parameters enable you to control copy processing:

  • FLASHCOPY enables you to specify whether FlashCopy image copies are required or preferred.
  • SVRSPECIAL controls special server processing for image copies.

NGTTAPE command

The NGTTAPE-command passes tape unit allocation data to BMC AMI Reorg.

OUTPUT command

The OUTPUT-command-for-BMC-AMI-Reorg passes allocation information to BMC AMI Reorg.

Automation control points

The following automation control points enable you to control copy processing:

Information
Example
//SYSIN   DD *
NGTTAPE LP (UNITNAME(CART) DDNCOUNT(2) RETPD(8))
REORG TABLESPACE database.%

In the following example, only a Local Primary (LP) copy is requested. Since this is the default copy destination the Reorg statement does not have to specify it.  The DDNCOUNT keyword mounts two tape drives for the LP copy to write copies in parallel.

In this example:

  • Only a local primary (LP) copy is requested.
  • The REORG statement does not need to specify the copy destination because it is the default.
  • The DDNCOUNT keyword mounts two tape drives for the LP copy to write copies in parallel.
Information
Example
//SYSIN   DD *
NGTTAPE LP (UNITNAME(VTS) DDNCOUNT(2) RETPD(8))
NGTTAPE RP (UNITNAME(VTSR) DDNCOUNT(2) RETPD(8))
REORG TABLESPACE database.%
    RECOVERYDDN(RP)

a Remote Primary (RP) copy is requested so a RECOVERYDDN keyword is added to the Reorg statement.  A COPYDDN keyword was still not required because the LP copy is required and will be produced.  Having the NGTTAPE LP statement directs it to tape rather than the default of DASD

Information
Example
//SYSIN   DD *
NGTTAPE LP (UNITNAME(VTS) DDNCOUNT(2) RETPD(8))
NGTTAPE LB (UNITNAME(VTS) DDNCOUNT(2) RETPD(8))
NGTTAPE RP (UNITNAME(VTSR) DDNCOUNT(2) RETPD(8))
NGTTAPE RB (UNITNAME(VTSR) DDNCOUNT(2) RETPD(8))
REORG TABLESPACE database.%
    COPYDDN(LP,LB) RECOVERYDDN(RP,RB)

NGTTAPE is used for all Db2 copy destinations.  The REORG statement requests the copy destinations and the NGTTAPE statement specifies its destination which defaults to DASD if not specified

Related topics

Reorganizing-objects-in-REORG-pending-REORP-status

Using-BMC-AMI-Reorg

Reorganizing-table-spaces

Reorganizing-indexes

Reorganizing-objects-in-REORG-pending-REORP-status

REORG-INDEX-option-descriptions

REORG-TABLESPACE-syntax-diagrams


 

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

BMC AMI Reorg for Db2 12.1