The status of an in-place (online) table
or a data partition
level reorganization. This is not applicable to classic (offline)
table reorganizations.
Table 1. Snapshot
Monitoring Information| Snapshot Level |
Logical Data Grouping |
Monitor
Switch |
|---|
| Table |
table_reorg |
Basic |
- Usage
- An in-place table or data partition reorganization
can be in
one of the following states (states are listed with their corresponding
defines from sqlmon.h):
- Started/Resumed: SQLM_REORG_STARTED
- Paused: SQLM_REORG_PAUSED
- Stopped: SQLM_REORG_STOPPED
- Completed: SQLM_REORG_COMPLETED
- Truncate: SQLM_REORG_TRUNCATE
- An
inplace table or data partition reorganization to reclaim extents
can be in one of the following states:
- Started: SQLM_REORG_STARTED
- Stopped: SQLM_REORG_STOPPED
- Completed: SQLM_REORG_COMPLETED
DB2 Version 9.7 for Linux, UNIX, and Windows