DB2 Version 9.7 for Linux, UNIX, and Windows

reorg_type - Table Reorganize Attributes monitor element

Table reorganize attribute settings.

Table 1. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Table	table_reorg	Basic

Usage

The following are possible attribute settings. Each attribute setting is based upon a bit flag value defined in db2ApiDf.h.

Allow Write Access: DB2REORG_ALLOW_WRITE
Allow Read Access: DB2REORG_ALLOW_READ
Allow No Access: DB2REORG_ALLOW_NONE
Recluster Via Index Scan: DB2REORG_INDEXSCAN
Reorg Long Field LOB Data: DB2REORG_LONGLOB
No Table Truncation: DB2REORG_NOTRUNCATE_ONLINE
Replace Compression Dictionary: DB2REORG_RESET_DICTIONARY
Keep Compression Dictionary: DB2REORG_KEEP_DICTIONARY
Reclaim Extents: DB2REORG_RECLAIM_EXTS

In addition to the preceding attribute settings, the following attributes are listed in the CLP output of the GET SNAPSHOT FOR TABLES command. These attribute settings are based on the values of other attribute settings or table reorganize monitor elements.

Reclustering: If the value of the reorg_index_id monitor element is non-zero, then the table reorganize operation has this attribute.
Reclaiming: If the value of the reorg_index_id monitor element is zero, then the table reorganize operation has this attribute.
Inplace Table Reorg: If the reorg_status monitor element has a value that is not null, then the in-place (online) reorganization method is in use.
Table Reorg: If the reorg_phase monitor element has a value that is not null, then the classic (offline) reorganization method is in use.
Recluster Via Table Scan: If the DB2REORG_INDEXSCAN flag is not set, then the table reorganize operation has this attribute.
Reorg Data Only: If the DB2REORG_LONGLOB flag is not set, then the table reorganize operation has this attribute.