Storage Analysis of Tables and Indexes with SAPDBA (SAP Library - SAP Database Guide: Informix (BC-DB-INF-DBA))

Storage Analysis of Tables and Indexes with SAPDBA

Purpose

You can use SAPDBA for Informix to analyze the following storage information on tables and indexes:

Dbspace
Fill level
Fragmentation
Largest free segment (that is, tables with critical next extent size)
Leaves and levels for indexes
Locking mode for table
Number and size of rows for table
Number of columns for table
Number of extents for table
Number of extents still available for table
Number of indexes for a table
Size

SAPDBA sorts the information according to various criteria. For example, you can view tables or indexes sorted by fill level, by size, and so on.

For more information, see Database Growth Monitoring.

Process Flow

You choose the SAPDBA analysis that you require from the following:

Tables

Analyzing Tables by Fill Level, Size, and Extents with SAPDBA

Analyzing Table Information with SAPDBA

Analyzing Tables for Critical Next Extent Size with SAPDBA

Indexes

Analyzing Indexes by Fill Level, Leaves, and Levels with SAPDBA

Analyzing Indexes of a Table with SAPDBA

Analyzing Index Information with SAPDBA

Analyzing a Tablespace with SAPDBA

Result

Having formed the best possible picture of the storage situation, you can now decide what action to take, if any. You might decide on the following actions:

Reorganize an object

Refer to Reorganization of Tables, Indexes, and Dbspaces with SAPDBA.

Extend a dbspace that is too full

Refer to Adding a Chunk with SAPDBA.

See also:

Informix documentatation