DB2 LUW Storage Manager (Revision #8)

With Aqua Data Studio 7.5 you can plan, initialize, allocate, manage, and tune DB2 UDB database objects for better performance

New enhanced Object Tab in Aqua Data Studio 7.5 displays :

• Detailed information of Tables and Indexes
• Table Storage now displays Table name, Tablespace, Type, Row Count, Index Size, Data Size, Pages Used, Cardinality, Pages Containing Row, Occupied Blocks and Created Date
• Index storage now includes Index Name, Index Type, Index Size, Clustered, Unique, Cardinality, Index Leaf Pages, Cluster Ratio, Sequential Pages and Created Date. You can quickly identify whether indexes are not created on Tables participating in SQL Queries
• Overall Object Storage information for Tablespaces. You can sort and quickly identify which Table or Index takes up more space. You can configure Storage and eliminate wasted storage

Object Tab - Display of the Tables and Indexes.

Documentation -> DB2 for LUW DBA Tools -> Storage Manager

Object Name: Name of the database object
Owner: Owner of the Table
Object Type: Type of the database object
Tablespace: Name of the tablespace containing the Table
Bufferpool: Name of the Bufferpool containing the Table
Table Size: Total Size occupied by the table
Column Count:
Cardinality: 
Data:
Indexes:
Pages Used:
Pages Containing Row:
Occupied Blocks:
Rows that Overflow:
NPAGES:
FPAGES:
Overflow:
Average Row Size:
Code Page:
Compression:
Lock Size:
Partition Mode:
Status:
Create Time:

Type = Index

Index Name: Name of the index object
Index Schema: Owner of the Index
Table Name: Name of the database object
Table Schema: Owner of the Table
Object Type: Whether Sytem or User Index
Tablespace: Name of the tablespace containing the index
Buffer Pool:Name of the Bufferpool containing the index
Index Type: Type of the index
Index Size: Size of the Index
Cardinality: The number of distinct values for a column is called index cardinality
Index Leaf Pages: Leaf pages are the lowest level index pages - the pages that contain index entries and information to the corresponding table rows
Cluster Ratio: The degree of data clustering of the index, represented as a percentage between 0 to 100
Rows: Number of rows in the index
Created On: Date on which this index was most recently analyzed