Reorganization of a LOB table space

You can reorganize a LOB table space separately from the base table space. Alternatively, you can specify AUX YES when you reorganize the base table space and the associated LOB table spaces are also reorganized.

For information about reorganizing the base and LOB table spaces together, see AUX YES.

The rest of this topic refers to reorganizing a LOB table space separately from the base table space.

The REORG utility statement syntax for a LOB table space is almost the same as the syntax for running REORG on any other table space. The only difference is that some options are not applicable to LOB table spaces, including the following options: Start of change

AUTOESTSPACE
AUX YES
DISCARD
DISCARDDN
INDREFLIMIT
NOPAD
NOSYSREC
OFFPOSLIMIT
PART
PREFORMAT
PUNCHDDN
REBALANCE
REPORTONLY
REUSE
ROWFORMAT
SAMPLE
SHRLEVEL NONE
SORTDATA
SORTDEVT
STATISTICS
UNLOAD ONLY
UNLOAD EXTERNAL
UNLOAD PAUSE
KEEPDICTIONARY

For SHRLEVEL REFERENCE or CHANGE, LOBs are unloaded to a shadow data set and physical space is reclaimed. If you specify SHRLEVEL REFERENCE or CHANGE, you must also specify LOG NO and take an inline image copy. In this case, no updates are logged during the REORG.

In DB2® 10 conversion mode, REORG SHRLEVEL NONE of a LOB table space is allowed, but a warning message is issued to indicate that this function will be deprecated. In DB2 10 new-function mode, REORG SHRLEVEL NONE of a LOB table space is non-operational. You can run it, but no reorganization is performed.