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 ** 2008/12/25 15:54:10 [1] |
Range of numeric values | Display format |
---|---|
0 to 999 | 0 to 999 |
1,000 to 999,499 | 1.00K to 999K |
999,500 to 999,499,999 | 1.00M to 999M |
999,500,000 to 999,499,999,999 | 1.00G to 999G |
999,500,000,000 to 999,499,999,999,999 | 1.00T to 999T |
Range of numeric values | Display format |
---|---|
0 to 999 | 0 to 999 |
1000 to 9999 | 1,000 to 9,999 |
100000000000000 to 999999999999999 | 100,000,000,000,000 to 999,999,999,999,999 |
1000000000000000 and greater | z,zzz,zzz,zzz,zzz,zz9E+zz9 (exponent format with 16 significant digits) |
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 following rules apply in the case of output in DAT format:
Table 15-3 Information output as condition analysis by RDAREA (logical analysis) in DAT format
Title bar | Description | Output format | Maximum length (bytes)#1 | RDAREA other than LOB RDAREA | LOB RDAREA | |||
---|---|---|---|---|---|---|---|---|
Table | Index | SQ | Table | Index | ||||
VERSION | HiRDB version | Character string (vv-rr) | 5 | O | O | O | O | O |
INF_GET_TIME | Date (year, month, date) and time the information collection was completed | Character string (yyyy/mm/dd hh:mm:ss) | 19 | O | O | O | O | O |
RDAREA_NAME | Name of target RDAREA | Character string | 30 | O | O | O | O | O |
SERVER | Name of server containing the RDAREA | Character string | 8 | O | O | O | O | O |
TOTAL_SEGMENT | Total number of segments in the RDAREA | Numeric value | 10 | O | O | O | O | O |
UNUSED_SEGMENT | Number of unused segments in the RDAREA | Numeric value | 10 | O | O | O | O | O |
UNUSED_SEGMENT_NOT_FREEZE | Number of unused segments in the RDAREA that are not in frozen update status | Numeric value | 10 | -- | -- | -- | O | O |
SEGMENT_SIZE | Segment size | Numeric value | 10 | O | O | O | O | O |
PAGE_SIZE | Page size | Numeric value | 10 | O | O | O | O | O |
ORIGINAL_RDAREA_NAME#2 | Original RDAREA name | Character string | 30 | O | O | O | O | O |
GENERATION_NUMBER#2 | RDAREA's generation number | Numeric value | 2 | O | O | O | O | O |
REPLICA_RDAREA_COUNT#2 | Number of replica RDAREAs | Numeric value | 2 | O | O | O | O | O |
HOLD_STATUS(HISTORY1) | RDAREA shutdown type (previous shutdown type before the RDAREA was released from shutdown status (if the RDAREA is currently shut down, the current shutdown type)): CMD: Command shutdown due to a HiRDB failure FLT: Error shutdown | Character string | 3 | O | O | O | O | O |
HOLD_CODE(HISTORY1) | RDAREA shutdown cause code (previous shutdown cause code before the RDAREA was released from shutdown status (if the RDAREA is currently shut down, the current shutdown cause code)) | Numeric value | 5 | O | O | O | O | O |
HOLD_TIME(HISTORY1) | RDAREA shutdown time (previous shutdown time before the RDAREA was released from shutdown status (if the RDAREA is currently shut down, the current shutdown time)) | Character string (yyyy/mm/dd hh:mm:ss) | 19 | O | O | O | O | O |
HOLD_STATUS(HISTORY2) | RDAREA shutdown type (for the shutdown immediately preceding History1): CMD: Command shutdown due to a HiRDB failure FLT: Error shutdown | Character string | 3 | O | O | O | O | O |
HOLD_CODE(HISTORY2) | RDAREA shutdown cause code (for the shutdown immediately preceding History1) | Numeric value | 5 | O | O | O | O | O |
HOLD_TIME(HISTORY2) | RDAREA shutdown time (for the shutdown immediately preceding History1) | Character string (yyyy/mm/dd hh:mm:ss) | 19 | O | O | O | O | O |
INF_KIND | Type of displayed information: TBL: Information about table in RDAREA IDX: Information about index in RDAREA SEQ: Information about sequence generator in RDAREA LBT: Information about table in LOB RDAREA LBX: Information about index in LOB RDAREA | Character string | 3 | O | O | O | O | O |
TABLE_NAME | Table identifier | Character string | 30 | O | -- | -- | O | -- |
INDEX_NAME | Index identifier | Character string | 30 | -- | O | -- | -- | O |
SEQUENCE_NAME | Sequence generator identifier | Character string | 30 | -- | -- | O | -- | -- |
AUTH_ID | Authorization identifier of the table, index, or sequence generator (for a data dictionary RDAREA, Data dictionary) | Character string | 30 | O | O | O | O | O |
STATUS | For a table One of the following statuses: TA_UNFINISH: Reload-not-completed data status N_RORG: Reorganization underway Null element: Other than the above For an index One of the following statuses: UNFINISH_0, UNFINISH_1, or UNFINISH_2: For details, see status in 15.3.1(2)(a) For an RDAREA other than a LOB RDAREA Null element: Other than the above | Character string | 13 | O | O | -- | O | O |
REFERENCE_PENDING_STATUS | Check pending status for referential constraint managed in the table information in the RDAREA: P: Check pending status Blank: Not check pending status (including when no referential constraint has been defined for the table) | Character string | 1 | O | -- | -- | -- | -- |
CHECK_PENDING_STATUS | Check pending status for check constraint managed in the table information in the RDAREA: P: Check pending status Blank: Not check pending status (including when no check constraint has been defined for the table) | Character string | 1 | O | -- | -- | -- | -- |
SEGMENT_REUSE | Number of segments specified for SEGMENT REUSE during execution of CREATE TABLE or ALTER TABLE: 0: A number of segments is not specified for SEGMENT REUSE. Null element: NO is specified for SEGMENT REUSE or SEGMENT REUSE is omitted. | Numeric value | 10 | O | -- | -- | -- | -- |
SEARCH_MODE | Page search mode: INS: New page allocate mode REU: Free page reuse mode | Character string | 3 | O | -- | -- | -- | -- |
REUSE_SEARCH_FAILURE | Number of times the mode changed from new page allocate to free page reuse and then changed back to new page allocate because there was no reusable free space; this value is reset to 0 at the following times:![]() ![]() ![]() | Numeric value | 10 | O | -- | -- | -- | -- |
REUSE_SEARCH | Number of times the mode changed from new page allocate to free page reuse; this value is reset to 0 at the following times:![]() ![]() ![]() | Numeric value | 10 | O | -- | -- | -- | -- |
USED_SEGMENT | Number of used segments | Numeric value | 10 | O | O | -- | O | O |
USED_SEGMENT_RATIO | Percentage (%) of segments that are used segments![]() ![]() ![]() ![]() | Numeric value | 3 | O | O | -- | O | O |
FULL_SEGMENT | Number of full segments | Numeric value | 10 | O | O | -- | -- | -- |
FULL_SEGMENT_RATIO | Percentage (%) of segments that are full segments![]() ![]() ![]() ![]() | Numeric value | 3 | O | O | -- | -- | -- |
SUM_SEGMENT | Total number of segments in the RDAREA | Numeric value | 10 | O | O | -- | O | O |
SEGMENT_OVER | Whether all segments are being or have been used: Y: All used N: Some not used | Character string | 1 | -- | -- | -- | O | O |
LAST_SEGMENT_IN_USE | Last segment in use (if SEGMENT_OVER is Y, the final segment) | Numeric value | 10 | -- | -- | -- | O | O |
TOTAL_SEGMENT_NUMBER | Total number of segments | Numeric value | 10 | -- | -- | -- | O | O |
LOBMAP_OVER | Whether all LOB management entries have been used: Y: All used N: Some not used | Character string | 1 | -- | -- | -- | O | O |
USED_PAGE | Number of used pages | Numeric value | 10 | O | O | -- | -- | -- |
USED_PAGE_RATIO | Percentage (%) of pages in all segments that are used pages![]() ![]() ![]() ![]() | Numeric value | 3 | O | O | -- | -- | -- |
FULL_PAGE | Number of full pages | Numeric value | 10 | O | O | -- | -- | -- |
FULL_PAGE_RATIO | Percentage (%) of pages in all segments that are full pages![]() ![]() ![]() ![]() | Numeric value | 3 | O | O | -- | -- | -- |
SUM_PAGE | Total number of pages in all segments in the RDAREA | Numeric value | 10 | O | O | -- | -- | -- |
COLLECT_ON_SEGMENT | Number of segments being released by pdreclaim | Numeric value | 10 | O | O | -- | -- | -- |
COLLECT_PREARRANGED_PAGE | Number of pages that can be released by pdreclaim | Numeric value | 10 | D | D | -- | -- | -- |
COLLECT_ON_PAGE | Number of pages being released by pdreclaim | Numeric value | 10 | -- | D | -- | -- | -- |
RATIO0_PAGE | Number of pages whose usage is 0% | Numeric value | 10 | D | D | -- | -- | -- |
RATIO0_PAGE_RATIO | Percentage (%) of pages whose usage is 0% | Numeric value | 3 | D | D | -- | -- | -- |
RATIO0_DEL_ROWID | Number of rows managed by remaining entries in pages whose usage is 0% | Numeric value | Mantissa part: 5, exponent part: 5 | -- | Z | -- | -- | -- |
RATIO1_PAGE | Number of pages whose usage is 1-10% | Numeric value | 10 | D | D | -- | -- | -- |
RATIO1_PAGE_RATIO | Percentage (%) of pages whose usage is 1-10% | Numeric value | 3 | D | D | -- | -- | -- |
RATIO1_DEL_ROWID | Number of rows managed by remaining entries in pages whose usage is 1-10% | Numeric value | Mantissa part: 5, exponent part: 5 | -- | Z | -- | -- | -- |
RATIO2_PAGE | Number of pages whose usage is 11-20% | Numeric value | 10 | D | D | -- | -- | -- |
RATIO2_PAGE_RATIO | Percentage (%) of pages whose usage is 11-20% | Numeric value | 3 | D | D | -- | -- | -- |
RATIO2_DEL_ROWID | Number of rows managed by remaining entries in pages whose usage is 11-20% | Numeric value | Mantissa part: 5, exponent part: 5 | -- | Z | -- | -- | -- |
RATIO3_PAGE | Number of pages whose usage is 21-30% | Numeric value | 10 | D | D | -- | -- | -- |
RATIO3_PAGE_RATIO | Percentage (%) of pages whose usage is 21-30% | Numeric value | 3 | D | D | -- | -- | -- |
RATIO3_DEL_ROWID | Number of rows managed by remaining entries in pages whose usage is 21-30% | Numeric value | Mantissa part: 5, exponent part: 5 | -- | Z | -- | -- | -- |
RATIO4_PAGE | Number of pages whose usage is 31-40% | Numeric value | 10 | D | D | -- | -- | -- |
RATIO4_PAGE_RATIO | Percentage (%) of pages whose usage is 31-40% | Numeric value | 3 | D | D | -- | -- | -- |
RATIO4_DEL_ROWID | Number of rows managed by remaining entries in pages whose usage is 31-40% | Numeric value | Mantissa part: 5, exponent part: 5 | -- | Z | -- | -- | -- |
RATIO5_PAGE | Number of pages whose usage is 41-50% | Numeric value | 10 | D | D | -- | -- | -- |
RATIO5_PAGE_RATIO | Percentage (%) of pages whose usage is 41-50% | Numeric value | 3 | D | D | -- | -- | -- |
RATIO5_DEL_ROWID | Number of rows managed by remaining entries in pages whose usage is 41-50% | Numeric value | Mantissa part: 5, exponent part: 5 | -- | Z | -- | -- | -- |
RATIO6_PAGE | Number of pages whose usage is 51-60% | Numeric value | 10 | D | D | -- | -- | -- |
RATIO6_PAGE_RATIO | Percentage (%) of pages whose usage is 51-60% | Numeric value | 3 | D | D | -- | -- | -- |
RATIO6_DEL_ROWID | Number of rows managed by remaining entries in pages whose usage is 51-60% | Numeric value | Mantissa part: 5, exponent part: 5 | -- | Z | -- | -- | -- |
RATIO7_PAGE | Number of pages whose usage is 61-70% | Numeric value | 10 | D | D | -- | -- | -- |
RATIO7_PAGE_RATIO | Percentage (%) of pages whose usage is 61-70% | Numeric value | 3 | D | D | -- | -- | -- |
RATIO7_DEL_ROWID | Number of rows managed by remaining entries in pages whose usage is 61-70% | Numeric value | Mantissa part: 5, exponent part: 5 | -- | Z | -- | -- | -- |
RATIO8_PAGE | Number of pages whose usage is 71-80% | Numeric value | 10 | D | D | -- | -- | -- |
RATIO8_PAGE_RATIO | Percentage (%) of pages whose usage is 71- 80% | Numeric value | 3 | D | D | -- | -- | -- |
RATIO8_DEL_ROWID | Number of rows managed by remaining entries in pages whose usage is 71-80% | Numeric value | Mantissa part: 5, exponent part: 5 | -- | Z | -- | -- | -- |
RATIO9_PAGE | Number of pages whose usage is 81-90% | Numeric value | 10 | D | D | -- | -- | -- |
RATIO9_PAGE_RATIO | Percentage (%) of pages whose usage is 81-90% | Numeric value | 3 | D | D | -- | -- | -- |
RATIO9_DEL_ROWID | Number of rows managed by remaining entries in pages whose usage is 81-90% | Numeric value | Mantissa part: 5, exponent part: 5 | -- | Z | -- | -- | -- |
RATIO10_PAGE | Number of pages whose usage is 91-100% | Numeric value | 10 | D | D | -- | -- | -- |
RATIO10_PAGE_RATIO | Percentage (%) of pages whose usage is 91-100% | Numeric value | 3 | D | D | -- | -- | -- |
RATIO10_DEL_ROWID | Number of rows managed by remaining entries in pages whose usage is 91-100% | Numeric value | Mantissa part: 5, exponent part: 5 | -- | Z | -- | -- | -- |
TOTAL_PAGE | Total number of used pages by percentage ranges | Numeric value | 10 | D | D | -- | -- | -- |
TOTAL_DEL_ROWID | Total number of rows managed by remaining entries | Numeric value | Mantissa part: 5, exponent part: 5 | -- | Z | -- | -- | -- |
BINARY_SEARCH_MODE | Page search mode in binary-only segments: INS: New page allocate mode REU: Free page reuse mode | Character string | 3 | O | -- | -- | -- | -- |
BINARY_REUSE_SEARCH_FAILURE | Number of times the mode changed from new page allocate to free page reuse and then changed back to new page allocate because there was no reusable free space in the binary-only segments; this value is reset to 0 at the following times:![]() ![]() ![]() | Numeric value | 10 | O | -- | -- | -- | -- |
BINARY_REUSE_SEARCH | Number of times the mode changed from new page allocate to free page reuse in the binary-only segments; this value is reset to 0 at the following times:![]() ![]() ![]() | Numeric value | 10 | O | -- | -- | -- | -- |
BINARY_USED_SEGMENT | Number of used binary-only segments | Numeric value | 10 | O | -- | -- | -- | -- |
BINARY_USED_SEGMENT_RATIO | Percentage (%) of binary-only segments that are used![]() ![]() ![]() ![]() | Numeric value | 3 | O | -- | -- | -- | -- |
BINARY_FULL_SEGMENT | Number of full binary-only segments | Numeric value | 10 | O | -- | -- | -- | -- |
BINARY_FULL_SEGMENT_RATIO | Percentage (%) of binary-only segments that are full![]() ![]() ![]() ![]() | Numeric value | 3 | O | -- | -- | -- | -- |
BINARY_SUM_SEGMENT | Total number of binary-only segments allocated to the table | Numeric value | 10 | O | -- | -- | -- | -- |
BINARY_USED_PAGE | Number of used pages in the binary-only segments | Numeric value | 10 | O | -- | -- | -- | -- |
BINARY_USED_PAGE_RATIO | Percentage (%) of pages in binary-only segments that are used![]() ![]() ![]() ![]() | Numeric value | 3 | O | -- | -- | -- | -- |
BINARY_FULL_PAGE | Number of full pages in binary-only segments | Numeric value | 10 | O | -- | -- | -- | -- |
BINARY_FULL_PAGE_RATIO | Percentage (%) of pages in binary-only segments that are full![]() ![]() ![]() ![]() | Numeric value | 3 | O | -- | -- | -- | -- |
BINARY_SUM_PAGE | Total number of pages in all binary-only segments allocated to the table | Numeric value | 10 | O | -- | -- | -- | -- |
BINARY_COLLECT_ON_SEGMENT | Number of binary-only segments being released by pdreclaim | Numeric value | 10 | O | -- | -- | -- | -- |
BINARY_COLLECT_PREARRANGED_PAGE | Number of pages in binary-only segments that can be released by pdreclaim | Numeric value | 10 | D | -- | -- | -- | -- |
BINARY_RATIO0_PAGE | Number of pages in binary-only segments whose usage is 0% | Numeric value | 10 | D | -- | -- | -- | -- |
BINARY_RATIO0_PAGE_RATIO | Percentage (%) of pages in binary-only segments whose usage is 0% | Numeric value | 3 | D | -- | -- | -- | -- |
BINARY_RATIO1_PAGE | Number of pages in binary-only segments whose usage is 1-10% | Numeric value | 10 | D | -- | -- | -- | -- |
BINARY_RATIO1_PAGE_RATIO | Percentage (%) of pages in binary-only segments whose usage is 1-10% | Numeric value | 3 | D | -- | -- | -- | -- |
BINARY_RATIO2_PAGE | Number of pages in binary-only segments whose usage is 11-20% | Numeric value | 10 | D | -- | -- | -- | -- |
BINARY_RATIO2_PAGE_RATIO | Percentage (%) of pages in binary-only segments whose usage is 11-20% | Numeric value | 3 | D | -- | -- | -- | -- |
BINARY_RATIO3_PAGE | Number of pages in binary-only segments whose usage is 21-30% | Numeric value | 10 | D | -- | -- | -- | -- |
BINARY_RATIO3_PAGE_RATIO | Percentage (%) of pages in binary-only segments whose usage is 21-30% | Numeric value | 3 | D | -- | -- | -- | -- |
BINARY_RATIO4_PAGE | Number of pages in binary-only segments whose usage is 31-40% | Numeric value | 10 | D | -- | -- | -- | -- |
BINARY_RATIO4_PAGE_RATIO | Percentage (%) of pages in binary-only segments whose usage is 31-40% | Numeric value | 3 | D | -- | -- | -- | -- |
BINARY_RATIO5_PAGE | Number of pages in binary-only segments whose usage is 41-50% | Numeric value | 10 | D | -- | -- | -- | -- |
BINARY_RATIO5_PAGE_RATIO | Percentage (%) of pages in binary-only segments whose usage is 41-50% | Numeric value | 3 | D | -- | -- | -- | -- |
BINARY_RATIO6_PAGE | Number of pages in binary-only segments whose usage is 51-60% | Numeric value | 10 | D | -- | -- | -- | -- |
BINARY_RATIO6_PAGE_RATIO | Percentage (%) of pages in binary-only segments whose usage is 51-60% | Numeric value | 3 | D | -- | -- | -- | -- |
BINARY_RATIO7_PAGE | Number of pages in binary-only segments whose usage is 61-70% | Numeric value | 10 | D | -- | -- | -- | -- |
BINARY_RATIO7_PAGE_RATIO | Percentage (%) of pages in binary-only segments whose usage is 61-70% | Numeric value | 3 | D | -- | -- | -- | -- |
BINARY_RATIO8_PAGE | Number of pages in binary-only segments whose usage is 71-80% | Numeric value | 10 | D | -- | -- | -- | -- |
BINARY_RATIO8_PAGE_RATIO | Percentage (%) of pages in binary-only segments whose usage is 71-80% | Numeric value | 3 | D | -- | -- | -- | -- |
BINARY_RATIO9_PAGE | Number of pages in binary-only segments whose usage is 81-90% | Numeric value | 10 | D | -- | -- | -- | -- |
BINARY_RATIO9_PAGE_RATIO | Percentage (%) of pages in binary-only segments whose usage is 81-90% | Numeric value | 3 | D | -- | -- | -- | -- |
BINARY_RATIO10_PAGE | Number of pages in binary-only segments whose usage is 91-100% | Numeric value | 10 | D | -- | -- | -- | -- |
BINARY_RATIO10_PAGE_RATIO | Percentage (%) of pages in binary-only segments whose usage is 91-100% | Numeric value | 3 | D | -- | -- | -- | -- |
BINARY_TOTAL_PAGE | Total number of used pages in binary-only segments by percentage ranges | Numeric value | 10 | D | -- | -- | -- | -- |
DEL_ROWID | Total number of managed rows in table or index deleted status | Numeric value | Mantissa part: 16, exponent part: 5 | Z | Z | -- | -- | -- |
DEL_ROWID_RATIO | Percentage (%) of the number of rows managed by remaining entries | Numeric value | 3 | -- | Z | -- | -- | -- |
ROWID_COUNT | Total number of rows managed by index | Numeric value | Mantissa part: 16, exponent part: 5 | -- | Z | -- | -- | -- |
SEQUENCE_CURRENT_VALUE | Current value of sequence generator | Numeric value | 39 | -- | -- | O | -- | -- |
SEQUENCE_CURRENT_VALUE_REVICE | Whether the current value of sequence generator needs to be corrected | Numeric value | 1 | -- | -- | O | -- | -- |
SEGMENT_REUSE_OPTION#3 | Reuse option value specified in SEGMENT REUSE in the table definition | Numeric value | 10 | O | -- | -- | -- | -- |
BRANCH_ROW_SEARCH_MODE#4 | Free area search mode for branch rows | Character string | 3 | O | -- | -- | -- | -- |
COLLECT_PREARRANGED_FULL_PAGE | Number of full pages that can be released by pdreclaim | Numeric value | 10 | D | -- | -- | -- | -- |
BINARY_BRANCH_ROW_SEARCH_MODE#4 | Free area search mode for branch rows in binary-only segments | Character string | 3 | O | -- | -- | -- | -- |
BINARY_COLLECT_PREARRANGED_FULL_PAGE | Number of full pages in binary-only segments that can be released by pdreclaim | Numeric value | 10 | D | -- | -- | -- | -- |
No. | Specification of SEGMENT REUSE and specified value | Specification of SEGMENT REUSE OPTION | Output | |
---|---|---|---|---|
1 | Specified | Other than NO | Specified | Specified value |
2 | Omitted | 0 | ||
3 | NO | -- | Null data | |
4 | Omitted | -- | -- | Null data |
No. | Specification of SEGMENT REUSE and specified value | SEGMENT REUSE OPTION value | Output | |
---|---|---|---|---|
1 | Specified | Other than NO | 2,3 |
|
2 | Other than 2,3 | Null data | ||
3 | NO | -- | Null data | |
4 | Omitted | -- | -- | Null data |
The results of condition analysis by RDAREA (logical analysis) can be analyzed as shown in the table below.
Table 15-4 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:
| ||
Number of used pages by percentage ranges | There are many pages whose usage percentage is 0% | Used free pages account for at least 30% of the total number of pages | Performance is affected adversely when there are many used free pages. You should release used free pages. |
Another table or index is defined in the same RDAREA | Unused pages can be used only by the table or index to which the segments containing those pages have been allocated. This means that if another table or index is defined in the same RDAREA, fewer pages are available to be allocated to the other table or index. You should release used free segments or perform reorganization. The number of unused pages is the difference between the number of pages whose usage is 0% and the number of used free pages. | ||
There are many pages whose usage percentage is low | Area that was once allocated remains as unreleased free area due to data deletion and updating. Such area cannot be reused. You should perform reorganization. | ||
There are many pages whose usage percentage is high | There is only a small amount of free space in the pages that can be allocated during data addition or updating. If either of the following is applicable, you should perform reorganization:
| ||
Ratio of the number of rows managed by remaining entries to the total number of rows managed by the index | High | There are many remaining entries. You should release used free pages or perform reorganization to avoid illegal lock-release waits and deadlocks, as well as adverse effects on search performance. For details about the effects of a large number of remaining entries, see the HiRDB Version 9 UAP Development Guide. | |
Low | If there are only a few remaining entries but many of the rows managed by the remaining entries are in a search range, search performance might be affected adversely. If the number of pages accessed during searches is large compared to the search hits count, performance is affected adversely and you should release free pages or perform reorganization. You can use the pdbufls command or check the UAP statistical report to determine the number of pages accessed. | ||
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 |