![[Contents]](FIGURE/CONTENT.GIF)
Nonstop Database, HiRDB Version 9 Command Reference
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
The database condition analysis facility references the HiRDB directory, analyzes the storage status of the data dictionary tables or the tables and indexes in user RDAREAs, then displays the analysis results.
You can execute the database condition analysis facility in the following units:
Condition analysis by RDAREA can be a logical analysis or a physical analysis.
The figure below (for logical analysis) and Figure 15-2 Condition analysis by RDAREA: physical analysis (for physical analysis) show condition analysis by RDAREA.
Figure 15-1 Condition analysis by RDAREA: logical analysis
![[Figure]](FIGURE/ZU150020.GIF)
Figure 15-2 Condition analysis by RDAREA: physical analysis
![[Figure]](FIGURE/ZU150030.GIF)
The figure below shows condition analysis by table, and Figure 15-4 Condition analysis by index shows condition analysis by index.
Figure 15-3 Condition analysis by table
![[Figure]](FIGURE/ZU150040.GIF)
Figure 15-4 Condition analysis by index
![[Figure]](FIGURE/ZU150050.GIF)
Cluster keys are analyzed and the incorrect-storage rate is displayed (the incorrect-storage rate indicates the degree of disorganization of tables or indexes).
The analysis results are displayed in the order of cluster keys and clustering data pages for each storage RDAREA.
Cluster keys are retrieved in the order of the key values, and the analysis results are displayed as follows:
The figure below shows the ratio of the number of storage position changes to the number of times the storage order was incorrect.
Figure 15-5 Ratio of number of storage position changes to number of times storage order was incorrect (%)
![[Figure]](FIGURE/ZU150060.GIF)
![[Figure]](FIGURE/ZUENG013.GIF)
: Storage position change.
The storage position change from Key 4 to Key 5 is in reverse order, creating an incorrect storage order. The incorrect storage order rate for this figure is:
Number of times storage order is incorrect/number of storage position changes = 1/2 = 50%
Clustering data pages are data pages in tables assigned to cluster keys. The storage position changes and the number of times the storage order was incorrect for row data when data in cluster key order was retrieved based on the storage position information for row data in the cluster key are displayed in the format page-unit/segment-unit (%).
When the storage condition becomes disorderly due to addition or updating of rows, either the incorrect storage order rate or the number of storage position changes, or both, will increase.
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.