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.

AUX

The AUX option specifies whether to reorganize associated LOB table spaces while reorganizing the base table space.

AUX_syntax.png

Currently, this option applies only when REORG PLUS invokes DSNUTILB. When not invoking DSNUTILB, REORG PLUS ignores this option.

If you do not specify this option, the default is AUX NO except in certain cases. When you do not specify this option, you are reorganizing a table space that contains a LOB column, and any of the following conditions exists, REORG PLUS invokes DSNUTILB. In this case, the Db2 REORG utility defaults to AUX YES:

  • You specify SHRLEVEL REFERENCE and REBALANCE.
  • You are reorganizing more than one partition of a partition-by-growth table space
  • You specify SHRLEVEL REFERENCE or SHRLEVEL CHANGE, and any partition is in REORP status.

Important

In REORG PLUS version 10.2 and earlier, the AUXREORG installation option enabled you to specify a default for the AUX command option. REORG PLUS no longer requires or uses this option.

YES

YES indicates that associated LOB table spaces are to be reorganized when you specify REORG TABLESPACE on the base table space. This option applies only to the LOB table spaces associated with the partitions that are being reorganized.

The DSNUTILB installation or command option must be set to YES.

Restrictions

AUX YES has the following restrictions:

  • If you are reorganizing a nonpartitioned base table space, REORG PLUS changes AUX YES to AUX NO.
  • REORG PLUS terminates if AUX YES is in effect and you specify UNLOAD PAUSE.

NO

NO indicates that only the base table space is to be reorganized when you specify REORG TABLESPACE on the base table space. Associated LOB table spaces are not reorganized.

Restrictions

REORG PLUS terminates if AUX NO is in effect for a table space that contains a LOB column and any participating partition is in REORP status.

REORG PLUS invokes DSNUTILB when the table space contains an inline LOB column whose length definition was altered before the reorganization.

Related topic

Basic-REORG-PLUS-processing-options

 

 

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