This section includes the following topics:

About the Objects tab

This tab enables you to see objects definitions, I/O activity, and space usage over time. This section provides a general description of how to use the Objects tab in your analysis of DB2 objects. For further information on a specific DB2 object, see DB2's relevant documentation.

How the Objects tab is structured

The Objects tab displays information on a selected entity and its associated entities. When you open the Objects tab the selected entity is by default Database Partition, meaning that information is displayed on the Database Partition level. When you launch the Objects tab from the Activity tab with a Table or Index entity, using the launch icon, the tab is launched in context with the entity you selected in the Activity tab.

If you open the Objects tab from another tab, the historical settings (those settings which were selected when you left the tab, such as the last entity you drilled down to) are taken into account and the information displayed the last time you viewed the tab is displayed (similar to clicking the History button and returning to a previous tab).

The selected entity is always reflected in the Tab heading, which serves as a point of orientation. The highest level entity you can view information for in the Objects tab is the Data Partition level. You can select a Data Partition from the Data Partition list.

The entities displayed in the Association area are associated with the selected entity displayed in the Main area. At times, the relationship between the entity displayed in the Main area and those displayed in the Association area is that of parent to child and sometimes it merely represents that there is a relationship between the selected entity and the entities displayed in the Association area.

About the Main area in the Objects tab

The Main area displays overview information for the entity selected in the Association area as well as its related entity. By default, the Objects tab opens displaying information on the Database entity and its last selected related entity. You can change the database to display by selecting the desired database in the Database Partition field at the top of the Main area and its related entity by clicking the Association Control button at the top of the Association area. You can also display information on a different entity by selecting the desired entity from the Association Control button list and the related entity by selecting it from the table displayed in the Association area.

About the Association area in the Objects tab

The Association area is comprised of the Association Control button for selecting the entity whose information you want to display and a table displaying the selected entity’s related information. Two entities, Tables and Indexes, display information in two views: the Dictionary tab and the Storage & Statistics tab. The Dictionary tab displays dictionary information for this entity and the Storage & Statistics tab displays statistics based on the last runstat information for this entity.

About Objects tab entities

The Objects tab displays information on different entities. This section provides an overview of all entities, their meaning, and their views.

The following entities can be examined in the Objects tab:

Schemata

The following table describes the information displayed for the Schemata entity.

Table 1 Schemata

ColumnDescription
SchemaSchema name.
OwnerOwner name.
DefinerThe user who defined the schema.
Creation TimeTime of schema creation.

Tables

Two association selector options are available:

  • Dictionary tab. Shows dictionary information for the table.
  • Storage & statistics tab. Shows table storage information and RUNSTATS information. This is the default view. The following table describes the information displayed in the Dictionary tab.

Table 2 Dictionary tab

ColumnDescription
NameTable name.
SchemaTable's schema.
TypeTemporary, MDC, MQT or normal.
TablespaceName of primary tablespace.
Statistics RunDate last analyzed.
Range PartitionedYes – for Range Partitioned table.
DB PartitionsThe number of DB partitions this table exists in.
IndexesThe number of indexes defined for this table.
LoggedNo or blank.
Lock ModeThe Lock Mode type.
Index TablespaceName of the tablespace which contains the indexes.
LOB TablespaceName of the tablespace which contains the LOBs.

The following table describes the information displayed in the Storage and Statistics tab.

Table 3 Storage and Statistics tab

ColumnDescription
NameTable name.
SchemaTable's schema.
TypeTemporary, MDC, MQT or normal.
TablespaceName of primary tablespace.
Statistics RunDate last analyzed.
Pages AllocatedHow many pages are allocated.
Pages UsedHow many pages contain actual data.
RowsHow many rows.
Ave. Row LenAverage row length (bytes).
Clustering FactorThe clustering factor of the clustering index (if one exists) or blank if no clustering index was defined.
Extent sizeSize of extent (from tablespace definitions).
% Free Pages% Free of pages.
% Overflows% of records overflowing.
Rows per PageRows / (# of used pages).

Indexes

The following table describes the information displayed in the Dictionary tab.

Table 4 Dictionary tab

ColumnDescription
NameIndex name.
SchemaIndex schema.
Table NameBase table name.
Key ColumnsThe number of participating columns in the index.
IncludesThe number of columns included in the index.
TypeClustering, Dimensions block, Block or blank for regular.
UniqueYes, No, or Primary.
ColumnsThe list of participating columns in the index.
Statistics RunTime last analyzed.
TablespaceName of the tablespace which contains the index.
Table SchemaThe table’s schema.

The following table describes the information displayed in the Storage and Statistics tab.

Table 5 Storage and Statistics tab

ColumnDescription
NameIndex name.
SchemaIndex schema.
TablespaceName of the tablespace which contains the index.
Statistics RunTime last analyzed.
Clustering FactorClustering factor or Cluster ratio if factor is not available.
LevelsHow many levels exist.
First Column DistinctsThe number of distinct first-key values.
Second Column DistinctsThe number of distinct keys using the first two columns.
Distinct ValuesThe number of distinct values.
LeafsHow many leaf pages are in use.
Key LengthThe key length.
% Deleted RowsThe percentage of rows marked ‘Deleted’.
Leaf DistributionAvg. length between leaf pages.
% Empty PagesPercentage of empty pages.
% FreePercentage of each index page to be reserved during initial index building.
Extent SizeTaken from tablespace definitions.

Views

The following table describes the information displayed for the Views entity.

Table 6 Views

ColumnDescription
View NameView name.
OwnerView owner.
DefinerName of view creator.
ValidIs the view valid.
TextUnformatted first N characters of view's definition.

Database Partition Groups

The following table describes the information displayed for the Database Partition Groups entity.

Table 7 Database Partition Groups

ColumnDescription
NameName of the partition group.
PartitionsNumber of partitions in this group.
DefinerName of the user who defined the group.
Create TimeTime group was created.

Tablespaces

The following table describes the information displayed for the Tablespaces entity.

Table 8 Tablespaces

ColumnDescription
NameTablespace name.
TypeDMS or SMS.
Data TypeAll, LOB, System temp or Declared temp.
BufferpoolName of the bufferpool associated with this tablespace.
Bufferpool SizeSize of bufferpool on all partitions.
Page SizePage size.
Pages AllocatedTotal tablespace size.
Pages UsedTotal tablespace used (only for DMS).
Extent SizeNumber of pages per extent.
Prefetch SizeDefined prefetch size or Automatic.
Defined in GroupThe name of the partitioned group.
OverheadDB2 internal parameter describing the overhead associated with the tablespace's disks.
Transfer RateDB2 internal parameter, describing the time it takes to read one page.
DefinerName of the user who defined the tablespace.
RemarksUser comments.

Bufferpools

The following table describes the information displayed for the Bufferpools entity.

Table 9 Bufferpools

ColumnDescription
NameBufferpool name.
Size (Pages)Bufferpool size.
Page SizePage size of the bufferpool.
Defined in GroupsComma separated list of the DB partition groups to which it belongs.
All Tablespaces SizeSize, in MB, of all tablespaces associated with this bufferpool.
TablespacesThe number of tablespaces defined to use this bufferpool.

Database Partitions

The following table describes the information displayed for the Database Partitions entity.

Table 10 Database Partitions

ColumnDescription
ServerServer name.
IDID of the partition.
Default on Server?Yes, if this is the default partition when connecting to the database on that machine.
Total MemoryTotal shared memory dedicated for this database partition.
Total Bufferpools SizeTotal shared memory dedicated for this partition's BPs.
Defined in GroupsComma separated list of DB partition groups in which this DB partition participates.
IDERA |  Products | Purchase | Support |  Community |  Resources |  About Us  | Legal
  • No labels