This utility analyzes the storage condition of all segments and pages for the tables and indexes that are stored in an RDAREA. Note, however, that for tables and indexes that have been partitioned and stored among several RDAREAs, this utility analyzes only those segments stored in the specified RDAREAs.
You can detect a disordered table or index and obtain the capacity status of a single RDAREA.
The following shows the results of condition analysis by RDAREA (logical analysis):
pddbst VV-RR(Object Option) ** RD Area Logical Analysis ** 2003/03/31 18:33:38 [1] |
Figure 15-9 Types of unfinished index by table (1/2)
Figure 15-10 Types of unfinished index by table (2/2)
Figure 15-11 Types of unfinished index by RDAREA (1/2)
Figure 15-12 Types of unfinished index by RDAREA (2/2)
pddbst VV-RR(Object Option) ** RD Area Logical Analysis ** 2003/04/03 12:36:43 [1] |
The results of condition analysis by RDAREA (logical analysis) can be analyzed as shown in Table 15-1.
Table 15-1 Analyzing the analysis results by RDAREA (logical analysis)
Status in the RDAREA | Description | ||
---|---|---|---|
Percentage of total unused pages in the table is less than the percentage of free pages per segment that was specified in the CREATE TABLE definition SQL statement. | Table data may be in one of the following statuses:
| ||
The total number of used index storage pages displayed in the analysis results is greater than the number of index storage pages obtained from the number of table storage rows. | The index may be in the following status:
| ||
Table with clustering | Used free pages | Many | Percentage of free pages per segment specified in CREATE TABLE is too large. If necessary, reorganize the table because used free pages have been created due to data addition, deletion, and updating.1 |
Few | If you are adding data, the table should be reorganized.1 | ||
Table without clustering | Used free pages | Many | Percentage of free pages per segment specified in CREATE TABLE is too large. If necessary, reorganize the table because used free pages have been created due to data addition, deletion, and updating.1 |
Few | If there are only a few unused segments in the RDAREA, expand the RDAREA as required.2 | ||
End-of-segment is Y | LOB column search performance may become poor. Reorganize the LOB RDAREA.1 | ||
End-of-Lobmap is Y | LOB column search performance may become poor. Reorganize the LOB column structure base table.1 |