DB2 LUW Storage Manager (Revision #21)

With the DB2 Storage Manager you can now use the "Object" tab to view the storage information of table and indexes for capacity planning.

The new enhanced Object tab displays:

• Detailed information of Tables and Indexes.
• Table Storage displays Table name, Tablespace, Type, Row Count, Index Size, Data Size, Pages Used, Cardinality, Pages Containing Row, Occupied Blocks and Created Date.
• Index storage includes Index Name, Index Type, Index Size, Clustered, Unique, Cardinality, Index Leaf Pages, Cluster Ratio, Sequential Pages and Created Date.
• Overall Object Storage information for Tablespaces. You can sort and quickly identify which Table or Index takes up more space.

Object Tab - Display of the Tables and Indexes.

Table Objects	Index Objects

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