Chat now with support
Chat with Support

Spotlight on DB2 6.9.3 - Getting Started Guide

Database Analysis drilldown Reorgs tab

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.

Columns in the History tab

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:

  • Success is shown if a reorganization completed successfully.

  • Fail is shown if a reorganization did not complete successfully.

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:  

  • Sort

  • Build

  • Replace

  • Index Recreate

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:  

  • Started/Resumed

  • Paused

  • Stopped

  • Completed

  • Truncate

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.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating