The Reorgs tab on the Database Analysis drilldown allows you to monitor table reorganizations for a database. The reorganizations include those that are currently in progress as well as those that are paused, stopped, or completed. For reorganizations that are in progress, the tab shows how much work has been completed so far and the phase currently being performed. For all reorganizations, the tab shows reorg type, status, start and end times, number of rows compressed, and the names of the table spaces involved.
All columns available for the Reorgs tab are listed below in alphabetic order. Initially, the tab contains Spotlight's default column selection. You can choose which columns to display and organize them in any order from left to right using the Organize Columns function. This can be selected from the right-click menu for column headers.
|
Column |
Description |
|
Completion |
The completion status of a table reorganization:
If a reorganization failed, check the History tab for diagnostic information. This is shown in the SQL Code and SQL State columns. |
|
Counter |
A measure that indicates how much of a reorganization has been or was completed. Check the Max Counter column to see the total amount of work for a reorganization. |
|
End |
The timestamp for the end of a table reorganization. This includes year, month, date, and hour, in that order. |
|
Index ID |
The ID of the index used for ordering table rows during reorganization. If an index was not specified for sorting, None is shown. |
|
Long Tbsp ID |
The identifier of the tablespace used for reorganizing long objects (those with LONG VARCHAR or LOB data). For partitioned tables, this is the tablespace used for each partition's LONG VARCHAR or LOB. |
|
Max Counter |
A measure that indicates the total amount of work for a reorganization. Check the Counter column to see the progress of a reorganization that is currently being performed. |
|
Max Phase |
The maximum number of phases for a reorganization. This value only applies to classic (offline) reorganizations. |
|
Name |
The name of the table that is being reorganized or was reorganized. |
|
Page Reorgs |
The number of page reorganizations performed for a table. |
|
Partition |
The ID of the data partition for which information is shown in other columns. This value only applies to partitioned tables. |
|
Phase |
The phase of a table reorganization currently being performed or last performed. One of the following can be shown:
This value only applies to classic (offline) table reorganizations. |
|
Phase Start |
The timestamp for the start of a certain phase of a table reorganization. This includes year, month, date, and hour, in that order. |
|
Reorg Type |
The method and settings specified for a reorganization. Multiple settings can be shown. The settings determine whether a reorganization is in-place (online) or classic (offline). They also determine whether write or read access is allowed during reorganization; whether data is reclustered in the order of a certain index; whether LOB data is reorganized; and whether space is reclaimed. |
|
Rows Compressed |
The number of rows compressed in a table during reorganization. If a reorganization is currently in progress, the value shown is a running count of rows that have been compressed. If a reorganization is complete, the value might not be equal to the total number of rows in a table. This is because some rows might have been rejected for compression. For more information, see the description for Rows Rejected. |
|
Rows Rejected |
The number of rows rejected for compression. Rows are not compressed during reorganization when their record length less than or equal to the minimum record length. If a reorganization is currently in progress, the value shown is a running count of rows that do not meet the compression requirement. |
|
Schema |
The schema of the table that is being reorganized or was reorganized. |
|
Start |
The timestamp for the start of a table reorganization. This includes year, month, date, and hour, in that order. |
|
Status |
The status of a table reorganization. One of the following states is shown:
This value only applies to in-place (online) table reorganizations. |
|
Tbsp ID |
The identifier of the tablespace used for reorganizing a table. For partitioned tables, this is the tablespace used for each partition. |
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
