You can use the detailed database analysis in the SAP/Informix database monitor to check the state of tables, indexes, and dbspaces on disk. For example, you can find out how large your database is, how large certain tables are, and which objects have an excessive number of extents. Checks for full dbspaces and missing indexes are particularly important.

1. Choose Tools ® CCMS ® Control/Monitoring ® Performance Menu ® Database ® Activity ® Detail Analysis Menu ® State on disk.

The screen Database Performance: Tables is displayed.

2. To check whether any database indexes are missing, select Missing Indexes.

A hierarchical list is displayed.

3. To find history information about tables, choose Goto ® Space Management ® Performance Database ® Of Tables.

The system only displays tables for which the storage parameters have changed.

4. To display all tables, choose History ® All objects on/off.

Storage Analysis of Tables and Indexes with SAPDBA

Dbspaces with SAPDBA

Management of Informix Database Growth