13.1.1 Executing the database condition analysis utility on a regular basis

The database condition analysis utility (pddbst command) should be executed periodically in order to check the data storage efficiency.

Organization of this subsection
(1) Checking table storage efficiency
(2) Checking index storage efficiency
(3) Checking cluster key and clustering data page storage efficiency
(4) Checking data storage efficiency in RDAREAs

(1) Checking table 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.

(2) Checking index 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.

(3) Checking cluster key and clustering data page storage efficiency

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:

(4) Checking data storage efficiency in RDAREAs

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:

Other methods for checking RDAREA utilization status
  • The pddbls -a command can be used to check RDAREA utilization status.
  • The RDAREA utilization status that is output during backup processing by the database copy utility (pdcopy command) can also be used to check the RDAREA storage efficiency.