Chat now with support
Chat with Support

Spotlight on DB2 6.9.3 - Getting Started Guide

Tablespace Analysis drilldown Ranges tab

The Ranges tab on the Tablespaces drilldown shows how ranges are defined for range partitioning in DMS tablespaces. When an aggregate tablespace row is selected, the tab shows partitioning information for a tablespace across all database partitions. When the row for an individual tablespace is selected, the tab shows partitioning information for the partition on which the tablespace is defied.

Note: Information in the Ranges tab applies only to DMS tablespaces. It does not apply to SMS tablespaces.

Columns in the Ranges tab

All columns available for the Ranges 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

Adjustment

Any offset into the container array in which a range starts.

Container ID

The ID that uniquely identifies a container within a range.

Containers

The number of containers in a range.

End Stripe

The number of the last stripe in a range.

Max Extent

The maximum extent number that is mapped by a range.

Max Page

The maximum page number that is mapped by a range.

Number

The number of a range in the tablespace map.

Offset

The offset from stripe 0 of the beginning of the stripe set to which a range belongs.

Start Stripe

The number of the first stripe in a range.

Stripe Set

The number of the stripe set to which a range belongs.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating