Storage management view - IBM DB2 9.7 for Linux, UNIX, and Windows

Use the Storage Management view to monitor the storage state of a partitioned database. The Storage Management view is the graphical interface to the Storage Management tool. In the Storage Management view, you can take storage snapshots for a database, a database partition group, or a table space.

When a table space snapshot is taken, statistical information is collected from the system catalogs and database monitor for tables, indexes, and containers defined under the scope of the given table space. When a database or database partition group snapshot is taken, statistical information is collected for all the table spaces defined in the given database or database partition group. When a database snapshot is taken, statistical information is collected for all the database partition groups within the database. Different types of storage snapshots can be used to help you monitor different aspects of storage:

Space usage can be monitored through snapshots of table spaces.
On partitioned databases only: Data skew (database distribution) can be monitored best through snapshots of database partition groups.
Cluster ratio of indexes can be captured through both database partition group snapshots and table space snapshots. The cluster ratio of indexes is presented through the detail view of the index folder.

The Storage Management view also enables you to set thresholds for data skew, space usage, and index cluster ratio. If a target object exceeds a specified threshold, the icons beside the object and its parent object in the Storage Management view are marked with a warning flag or an alarm flag.

Note: You can only set data skew thresholds for partitioned databases.

Use the Storage Management launchpad to guide you through the tasks necessary to set up the Storage Management tool. The Storage Management tool provides you with the ability to manage the storage of a specific database or database partition over the long term. It also allows you to capture data distribution snapshots and to view storage history. Three stored procedure functions are automatically created for the storage management tool when the database is created: SYSPROC.CREATE_STORAGEMGMT_TABLES, SYSPROC.DROP_STORAGEMGMT_TABLES, and SYSPROC.CAPTURE_STORAGEMGMT_INFO. Their respective packages are bound on demand.

Note: You can open the Storage Management Setup launchpad from a database, database partition group, or table space object in the Control Center. The launchpad will lead you through the one-time-only setup process for using the Storage Management tool. After you have captured a snapshot for the selected object or its parent object using the Storage Management Setup launchpad, you will be able to open the Storage Management view.