The utility analyzes the storage condition of all segments and all pages in an RDAREA without taking into account tables or indexes.
The utility displays the storage condition of all segments and all pages in an RDAREA. From the displayed analysis results, you can determine the RDAREA's utilization efficiency and capacity status.
The following shows the results of condition analysis by RDAREA (physical analysis):
pddbst VV-RR(Object Option) ** RD Area Physical Analysis ** 2002/03/29 16:40:10 [1] |
Table 15-2 Results of condition analysis by RDAREA (physical analysis) in DAT format
Title bar1 | Description | Output format | Max. length (bytes)2 |
---|---|---|---|
VERSION | HiRDB version | Character string (vv-rr) | 5 |
INF_GET_TIME | Date (year, month, date) and time that information acquisition was completed | Character string (yyyy/mm/dd hh:mm:ss) | 19 |
RDAREA_NAME | Name of the RDAREA | Character string | 30 |
SERVER | Name of the server containing the RDAREA | Character string | 8 |
MAX_SUM_SEGMENT | Maximum total number of segments in the RDAREA | Numeric value | 10 |
MAX_SUM_PAGE | Maximum total number of pages in the RDAREA | Numeric value | 10 |
SPECIFIED_RDAREA_COUNT | Number of RDAREAs to be analyzed | Numeric value | 10 |
ANALYZED_RDAREA_COUNT | Number of RDAREAs analyzed normally | Numeric value | 10 |
SEGMENT_SIZE | Number of pages per segment | Numeric value | 10 |
PAGE_SIZE | Page size | Numeric value | 10 |
HOLD_STATUS(HISTORY1)5 | RDAREA shutdown type (type of the last shutdown that was released; or if RDAREA is currently shut down, the current shutdown type): CMD: Command shutdown by HiRDB error detection FLT: Error shutdown | Character string | 3 |
HOLD_CODE(HISTORY1) | RDAREA shutdown cause code (cause code of the last shutdown that was released, or if RDAREA is currently shut down, the current shutdown cause code) (For details about the shutdown cause code, see the description for the text format.) | Numeric value | 5 |
HOLD_TIME(HISTORY1)5 | RDAREA shutdown time (time of the last shutdown that was released; or if RDAREA is currently shut down, the current shutdown time) | Character string (yyyy/mm/dd hh:mm:ss) | 19 |
HOLD_STATUS(HISTORY2)5 | RDAREA shutdown type (shutdown type immediately preceding History1): CMD: Command shutdown FLT: Error shutdown | Character string | 3 |
HOLD_CODE(HISTORY2) | RDAREA shutdown cause code (shutdown cause code immediately preceding History1) (For details about the shutdown cause code, see the description for the text format.) | Numeric value | 5 |
HOLD_TIME(HISTORY2)5 | RDAREA shutdown time (shutdown time immediately preceding History1) | Character string (yyyy/mm/dd hh:mm:ss) | 19 |
FREEZE_SPECIFIED3 | Whether or not frozen update was specified for the RDAREA: Y: Frozen update was specified with the pddbfrz command N: Frozen update was not specified with the pddbfrz command | Character string | 1 |
UNUSED_SEGMENT | Total number of unallocated segments in the RDAREA | Numeric value | 10 |
UNUSED_SEGMENT_NOT_FREEZE3 | Total number of unallocated segments in HiRDB files that are not in frozen update status in the RDAREA | Numeric value | 10 |
USED_SEGMENT | Number of used segments | Numeric value | 10 |
USED_SEGMENT_RATIO | Percentage of used segments![]() ![]() ![]() | Numeric value | 3 |
FULL_SEGMENT | Number of full segments | Numeric value | 10 |
FULL_SEGMENT_RATIO | Percentage of full segments![]() ![]() ![]() | Numeric value | 3 |
SUM_SEGMENT | Total number of segments in the RDAREA | Numeric value | 10 |
SEGMENT_OVER3 | Whether or not all segments are in use or have been used: Y: Used N: Not used | Character string | 1 |
LAST_SEGMENT_IN_USE3 | Last segment in use (if end-of-segment is Y, the last segment) | Numeric value | 10 |
TOTAL_SEGMENT_ NUMBER3 | Total number of segments | Numeric value | 10 |
LOBMAP_OVER3 | Whether or not all LOB management entries have been used: Y: Used N: Not used | Character string | 1 |
USED_LOB_ MANAGEMENT_ENTRY_NUMBER | Information used by the system | Numeric value | 10 |
TOTAL_LOB_ MANAGEMENT_ENTRY_NUMBER | Information used by the system | Numeric value | 10 |
USED_PAGE | Number of used pages | Numeric value | 10 |
USED_PAGE_RATIO | Percentage of used pages![]() ![]() ![]() | Numeric value | 3 |
FULL_PAGE | Number of full pages | Numeric value | 10 |
FULL_PAGE_RATIO | Percentage of full pages![]() ![]() ![]() | Numeric value | 3 |
SUM_PAGE | Total number of pages in all segments in the RDAREA | Numeric value | 10 |
AUTO_EXTEND_USE | Usage status of automatic extension facility: USE: Used NOUSE: Not used The last HiRDB file displayed in the HiRDB file information uses the automatic extension facility. | Character string | 5 |
AUTO_EXTEND_SEGMENT | Number of extended segments | Numeric value | 5 |
AUTO_EXTEND_STATUS | Automatic extension facility suppression status: SUP: Suppressed NOSUP: Not suppressed | Character string | 5 |
ERROR_CODE | Error code for an automatic extension error | Numeric value | 5 |
HiRDB_FILE_NAME | HiRDB file name in the RDAREA (absolute path name) | Character string | 167 |
FILE_SIZE | HiRDB file size (total number of segments) | Numeric value | 10 |
EXTENT_COUNT | HiRDB file partition storage count | Numeric value | 3 |
MAX_EXTENT_COUNT | Maximum HiRDB file partition storage count value | Numeric value | 3 |
USED_SEGMENT_IN_FILE3 | Number of used segments in HiRDB file | Numeric value | 10 |
TOTAL_SEGMENT_IN_FILE3 | Total number of segments in HiRDB file | Numeric value | 10 |
FREEZE_STATUS3 | Frozen update status of HiRDB file: U: Not in frozen update status (when a backup is made, this HiRDB file must be backed up) F: In frozen update status (if the HiRDB file was backed up after the displayed date and time, there is no need to back it up again) | Character string | 1 |
FREEZE_TIME3 | Frozen update status change date and time: ****/**/** **:**:**: The file has not been placed in frozen update status since the RDAREA was created or reinitialized Other: Date and time that frozen update status was set or released | Character string (yyyy/mm/dd hh:mm:ss) | 19 |
ORIGINAL_RDAREA_NAME4 | Original RDAREA name | Character string | 30 |
GENERATION_NUMBER4 | Generation number of the RDAREA | Numeric value | 2 |
REPLICA_RDAREA_COUNT4 | Number of replica RDAREAs | Numeric value | 2 |
The results of condition analysis by RDAREA (physical analysis) can be analyzed as shown in Table 15-3.
Table 15-3 Analyzing the analysis results by RDAREA (physical analysis)
Status in the RDAREA | Description | ||||
---|---|---|---|---|---|
Entire RDAREA | Unused segments | Many | There is sufficient capacity. | ||
Few | Used free pages | Many | The RDAREA is not being used efficiently. Execute condition analysis by RDAREA (logical analysis), check for a table or index that has many used segments and unused pages; if necessary, reorganize such a table or index or release free pages.1 | ||
Few | There is not enough capacity. Extend the RDAREA.2 |
A user LOB RDAREA can be analyzed as follows:
Percentage of used segments | End-of-segment | Description |
---|---|---|
Large (there are only a few unused segments) | Y | There is not enough capacity and database access performance has been affected adversely. Expand the user LOB RDAREA and reorganize the table or index.1, 2 |
N | There is not enough capacity. The user LOB RDAREA must be extended.1 | |
Small (there are many unused segments) | Y | Database access performance has been affected adversely. Reorganize the table or index.2 |
N | No action is necessary. |