REORG PLUS features that require DSNUTILB

REORG PLUS invokes DSNUTILB to enable new features quickly. For this version, REORG PLUS invokes DSNUTILB to enable the following features.

LOB objects

REORG PLUS invokes DSNUTILB when reorganizing LOB objects in the following cases:

Reorganizing LOB table spaces when SHRLEVEL NONE or SHRLEVEL CHANGE is in effect
Reorganizing LOB table spaces and the base table space in the same job step, provided one of the following conditions also exists:
- You specify AUX YES.
- You do not specify the AUX option but any of the following conditions exist, which causes the DB2 REORG utility to default 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.
Reorganizing base table spaces or LOB table spaces when pending definition changes exist on them
Reorganizing table spaces in which the length of an inline LOB column has been altered
Reorganizing indexes on an inline LOB column, or reorganizing table spaces that contain those indexes

For more information about reorganizing LOB objects, see Reorganizing-LOB-data.

REORG PLUS invokes DSNUTILB to reorganize the following additional types of table spaces:

Table spaces that contain tables that are defined as ORGANIZE BY HASH
REORG PLUS natively reorganizes indexes on tables that are defined as ORGANIZE BY HASH.
Table spaces that contain certain pending definition changes
For most pending definition changes, REORG PLUS materializes the change and reorganizes the object natively. For more information, see Reorganizing-objects-with-pending-definition-changes.
Table spaces that contain columns that are defined with a CCSID specification
(SPE2104
) Table spaces that contain columns that are defined with BUSINESS_TIME INCLUSIVE/INCLUSIVE
Table spaces that contain any of the following types of indexes:
- Indexes that contain a key derived from certain expressions
  REORG PLUS natively supports some indexes on expression. For more information, see Indexes-on-expression.
- Indexes that contain keys with random ordering
- Indexes that are defined with EXCLUDE NULL KEYS
- (SPE2104
  ) Indexes that are defined with INCLUDE DECFLOAT
- Nonpartitioned indexes in which some, but not all, logical partitions are in RREPL status.
(BMC.DB2.SPE2210) Table spaces that contain a mixture of fixed length and Huffman compression across the partitions.

REORG PLUS invokes DSNUTILB to reorganize the following additional types of indexes:

Indexes that contain certain pending definition changes
For most pending definition changes, REORG PLUS materializes the change and reorganizes the object natively. For more information, see Reorganizing-objects-with-pending-definition-changes.
Indexes that contain a key derived from certain expressions, including those on inline LOB columns and those on columns that are defined with a CCSID specification
REORG PLUS natively supports some indexes on expression. For more information, see Indexes-on-expression.
Indexes that contain keys with random ordering
Nonpartitioned indexes in which some, but not all, logical partitions are in RREPL status.

REORG PLUS invokes DSNUTILB when any of the following conditions exist:

An object is in RREPL status and SHRLEVEL NONE or SHRLEVEL CHANGE is in effect.
You specify RBALRSN_CONVERSION EXTENDED and all of the following conditions exist:
- You are reorganizing a versioned XML table space.
- The START_TS and END_TS column is currently defined as BINARY(8).
- You are reorganizing all partitions.
Specification of noncontiguous partitions when all of the following conditions exist:
- You are reorganizing a table space whose partition limit keys were altered before the reorganization.
- You are not rebalancing partitions during the reorganization.
- Your version of Db2 supports the ability to specify non-contiguous partitions.

REORG PLUS calls DSNUTILB any of the following tables spaces are defined with PAGENUM RELATIVE:

A table space that contains a table with an XML column
An XML table space
A user-defined XML index on a table
Any LOB table space associated with a base table space
A table space that contains a table with a LOB column
A table space with an associated index that is defined with COMPRESS YES
A table space is defined with PAGENUM RELATIVE and an ALTER LIMIT KEY has been executed (pending DDL).

(BMC.DB2.SPE2401)REORG PLUS calls DSNUTILB to materialize pending column alters if any of the following conditions exist:

LOBs or XML objects
Other pending alters for the object are present in SYSIBM.SYSPENDINGDDL.
The column being altered is an index key.
Altering FLOAT or DECFLOAT columns
Conversion from variable data types to fixed length data types such as VARCHAR to CHAR and VARBINARY to BINARY
The object contains GRAPHIC, VARGRAPHIC or MIXED DATA types.