The utility analyzes the segment status of a table or index storage page and the status of all storage pages by RDAREA.
You can determine the degree of disorganization of tables or indexes. For a table or index that has been partitioned and stored in multiple RDAREAs, you can determine whether or not partitions are distributed uniformly among the RDAREAs.
The following shows the results of condition analysis by table or index:
pddbst VV-RR(Object Option) ** Table Analysis ** 2003/03/31 18:53:24 [1] |
pddbst VV-RR(Object Option) ** Table Analysis ** 2003/04/03 12:37:22 [1] |
pddbst VV-RR(Object Option) ** Index Analysis ** 2003/03/31 18:56:00 [1] |
pddbst VV-RR(Object Option) ** Index Analysis ** 2002/03/29 18:05:06 [1] |
You can analyze the results of condition analysis by table or index in the same manner as for condition analysis by RDAREA (logical analysis).
If the storage rows are not distributed uniformly among RDAREAs, you are not making the best use of the HiRDB/Parallel Server's performance. In such a case, take appropriate measures, such as checking and revising key range partitioning or applying flexible hash partitioning or FIX hash partitioning (or changing the hash functions). The result should be to partition the storage uniformly among the RDAREAs.
If you have analyzed the status of an RDAREA the stores the LOB attribute of a plug-in-provided abstract data type or an RDAREA that stores a plug-in index, the percentage of used segments in the RDAREA depends on the method used by the plug-in to allocate segments.