Indicates the reorganization phase of the table.
For partitioned
tables, this will also indicate the reorganization phase for each
data partition. This applies to offline table reorganizations only.
Table 1. Snapshot Monitoring
Information| Snapshot
Level |
Logical Data Grouping |
Monitor Switch |
|---|
| Table |
table_reorg |
Basic |
Usage
For
partitioned tables, the reorganization
occurs on a data partition by data partition basis. For classic table
reorganization, the following phases are possible (phases are listed
with their corresponding defines from the
sqlmon.h file):
- Sort: SQLM_REORG_SORT
- Build: SQLM_REORG_BUILD
- Replace:
SQLM_REORG_REPLACE
- Index Recreate: SQLM_REORG_INDEX_RECREATE
- Dictionary Build: SQLM_REORG_DICT_SAMPLE
For partitioned tables, the Index Recreate
phase for partitioned indexes (if any) might be directly entered after
the replace phase for that data partition. The reorg_phase element
will indicate the Index Recreate phase only after the successful completion
of all prior phases on every data partition.
During
XDA object compression, the XML data reorganization phase involves
reorganizing the XML storage object of the table. The XML dictionary
build phase involves attempting to create a compression dictionary
for the XML storage object. For XDA object compression, the following two phases are possible:
- XML
Reorg: SQLM_REORG_XML_DATA
- XML Dictionary
Build: SQLM_REORG_XML_DICT_SAMPLE
For
partitioned tables, where reclamation of extents is being performed,
the following phases are possible:
- Scan: SQLM_REORG_SCAN
- Drain:
SQLM_REORG_DRAIN
- Release: SQLM_REORG_RELEASE
DB2 Version 9.7 for Linux, UNIX, and Windows