The database condition analysis utility (pddbst command) should be executed periodically in order to check the data storage efficiency.
Table storage efficiency is checked by executing the database condition analysis utility's condition analysis by table. The obtained information is used to determine whether or not the following procedures are necessary:
Condition analysis by table cannot be applied to a table for which an abstract data type is defined. In such a case, condition analysis by RDAREA (physical analysis) must be used in order to check the table's data storage efficiency.
Index storage efficiency is checked by executing the database condition analysis utility's condition analysis by index. The obtained information is used to determine whether or not the following procedures are necessary:
Note, however, that condition analysis by index does not obtain information on plug-in indexes.
Cluster key and clustering data page storage efficiency are checked by executing the database condition analysis utility's cluster key and clustering data page storage condition analysis. The obtained information is used to determine whether or not the following procedures are necessary:
Data storage efficiency in RDAREAs is checked by executing the database condition analysis utility's condition analysis by RDAREA. The obtained information is used to determine whether or not the following procedures are necessary: