Important We are integrating BMC AMI LOBMaster technology into the BMC AMI Reorg product and discontinuing BMC AMI LOBMaster as a separate product. For the latest integrated documentation, see BMC AMI Reorg for Db2 13.1.

+COPY


The +COPY parameter enables you to specify during runtime, whether to produce copies during a reorganization and set objects to copy-pending status. To make the +COPY parameter available, set NOCOPYALLOWED to YES. 

Important

  • You can set the NOCOPYALLOWED parameter during configuration only.
  • +COPY(NO) has no effect on the allocation of work data sets.
  • Running BMC AMI Reorg with +COPY(NO) parameter results in the object being left in RW,COPY after successful reorg. The potential also exists for the reorg to leave the object in RW,COPY but not complete the reorg. This can occur if the final DRAIN(ALL) fails. To avoid this, use +COPY(NO,n,NOPENDING) where n is a number(0-15).


Warning

If you specify +COPY(NO), reorganized objects will not be recoverable. BMC recommends that you specify +COPY(NO) only in testing environments to reduce CPU and elapsed time.

plusCOPY.png

YES

(default) BMC AMI Reorg produces copies of objects during a reorganization with a return code of 0.

BMC AMI Reorg specifies this option if you specified NOCOPYALLOWED (NO) during configuration (even if you specify +COPY(NO,returnCode)).

If BMC AMI Reorg fails to produce a copy, the return code will be 16.

NO,returnCode

BMC AMI Reorg does not produce copies of objects during a reorganization. This option is available only if you specified NOCOPYALLOWED(YES) during configuration.

The default return code is 4, but you can specify another return code value between 0 through 15 to indicate that BMC AMI Reorg did not make copies during the reorganization.

PENDING

(default) BMC AMI Reorg sets reorganized objects to copy pending status.

This option is available only if you have specified the following settings:

  • NOCOPYALLOWED (YES) during configuration
  • +COPY(NO,returnCode) during runtime

NOPENDING

BMC AMI Reorg does not set reorganized objects to copy pending status.

This option is available only if you have specified the following settings:

  • NOCOPYALLOWED(YES) during configuration
  • +COPY(NO,returnCode) during runtime

Important

For the rules that apply to parameter syntax, see Parameter syntax rules.

 

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