Space announcement This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

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 exist, 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

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.


 

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