To check the table storage efficiency, use one of the following methods:

• HiRDB Control Manager's database condition analysis
• Database condition analysis utility's condition analysis by table

The obtained information is used to determine whether the following procedures are needed:

• Table reorganization
• Releasing used free pages or used free segments
• Deletion of unneeded rows
• Changing the table row partitioning storage conditions
• Changing the hash function
• Re-creating or reorganizing indexes
• Expansion, re-initialization, addition, or deletion of RDAREAs

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.

To check the index storage efficiency, use one of the following methods:

• HiRDB Control Manager's database condition analysis
• Database condition analysis utility's condition analysis by index

The obtained information is used to determine whether the following procedures are needed:

• Re-creating or reorganizing indexes
• Releasing used free pages or used free segments
• Reducing the number of index page splits

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 the following procedures are necessary:

• Table reorganization
• Redefinition of a table with a cluster key specified and without the index component column containing many duplicated data items
• Reevaluation of the column structure in the index definition

To check the data storage efficiency in RDAREAs, use one of the following methods:

• HiRDB Control Manager's database condition analysis
• Database condition analysis utility's condition analysis by RDAREA

The obtained information is used to determine whether the following procedures are needed:

• Table reorganization
• Re-creating or reorganizing indexes
• Releasing used free pages or used free segments.
• Changing the table row partitioning storage conditions
• Changing the hash function
• Expansion, re-initialization, addition, or deletion of RDAREAs

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.

HiRDB Control Manager's database condition analysis function enables you to visually check the database storage status. The following explains how to use this function:

1. Start HiRDB Control Manager - Console.
   For details about how to start HiRDB Control Manager - Console, see F.1 Starting HiRDB Control Manager - Console.
   
2. Register the HiRDB server that is to be subject to processing.
   Skip this step if the HiRDB server has already been registered. For details about the registration method, see F.2 Registering Management HiRDB.
   
3. From the tab menu, select Data Maintenance and then Database Condition Analysis to display the Database Condition Analysis Utility window.
4. Select the target to be checked in the Information type drop-down list:
   
   • To check table storage efficiency
     Select User table.
     
   • To check index storage efficiency
     Select User indexes.
     
   • To check RDAREA storage efficiency
     Select RDAREAs.
     
   When you click the Information type drop-down list, a list of target resources is displayed. From this list, select the resources (tables, indexes, or RDAREAs) that you want to check.
   
5. Click the Condition analysis button.
   The results of condition analysis are displayed under Page usage status.
   You can use the buttons displayed in the upper part of the window to perform various operations, such as reorganizing tables and releasing free pages. For details about the page usage status trend and corrective measures, see HiRDB Control Manager Help.