15.3.2 Condition analysis by RDAREA (physical analysis)

The utility analyzes the storage condition of all segments and all pages in an RDAREA without taking into account tables or indexes.

Organization of this subsection
(1) Purpose
(2) Analysis results
(3) Analyzing the analysis results

(1) Purpose

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.

(2) Analysis results

The following shows the results of condition analysis by RDAREA (physical analysis):

Explanation
RDAREA information is displayed in ascending order of the RDAREA names. HiRDB file information is displayed in the order of the physical file IDs.
  1. Date and time of completion of acquisition of the information required for this condition analysis, in the format YYYY/MM/DD hh:mm:ss:
    YYYY: Year. MM: Month. DD: Date. hh: Hour. mm: Minute. ss: Second.
  2. Maximum total number of segments in the analyzed RDAREAs.
  3. Maximum total number of pages in the analyzed RDAREAs.
  4. Number of specified RDAREAs and number of RDAREAs analyzed successfully.
  5. Name of an analyzed RDAREA.
  6. Name of the server managing the RDAREA.
  7. Total number of unused segments in the RDAREA. The parentheses enclose the total number of unused segments in the HiRDB files that are not in the frozen update status in the corresponding RDAREA.
  8. Segment size (number of pages per segment).
  9. Page size (in bytes).
  10. Percentage ratio of used segments:
    [Figure]number of used segments/value of 14 [Figure][Figure] 100 (%)
  11. Percentage ratio of full segments:
    [Figure]number of full segments/value of 14 [Figure][Figure] 100 (%)
  12. Number of used segments.
  13. Number of full segments.
  14. Total number of segments in the RDAREA (number of used segments + number of unused segments).
  15. Percentage ratio of used pages:
    [Figure]number of used pages/value of 19 [Figure][Figure] 100 (%)
  16. Percentage ratio of full pages:
    [Figure]number of full pages/value of 19 [Figure][Figure] 100 (%)
  17. Number of used pages.
  18. Number of full pages.
  19. Total number of pages in the segments in the RDAREA (number of used pages + number of unused pages).
  20. Utilization status of the automatic extension facility:
    USE: Automatic extension facility is used.
    NOUSE: Automatic extension facility is not used.
    The HiRDB file indicated as the last HiRDB File Name is subject to automatic extension.
  21. Number of extension segments.
  22. Suppression status of the automatic extension facility:
    SUP: Suppressed.
    NOSUP: Not suppressed
  23. Error code in the event of an automatic extension error.
    -1556:
    Take one of the following actions:
    [Figure]Use the pdfbkup, pdfmkfs, and pdfrstr commands to integrate the extents of the HiRDB file system area that contains the corresponding HiRDB file system.
    [Figure]Use pdmod to expand the RDAREA.
    Other:
    See the list of HiRDB file system error codes in the manual HiRDB Version 8 Messages.
  24. HiRDB file name in the corresponding RDAREA.
  25. Total number of segments for the HiRDB file.
  26. Number of HiRDB file segments stored/maximum number of segments.
  27. Whether or not the order is lost in a LOB RDAREA:
    Y: Order is lost.
    N: Order is not lost.
  28. Position information indicating that the segment being used is the last segment; this is indicated in a last position/total number of segments format; always indicates the last segment when {27} is Y.
  29. Whether or not the LOB management entries are all used:
    Y: All are used.
    N: There are unused entries.
  30. Name of the original RDAREA.
  31. Generation number of the corresponding RDAREA.
  32. Number of replica RDAREAs.
  33. Shutdown history of the corresponding RDAREA.
    History1: Shutdown information immediately before the shutdown was released (if the RDAREA is currently shut down, this field displays the current shutdown information)
    History2: Shutdown information immediately preceding History1
  34. Shutdown type of the corresponding RDAREA. If there is no history, this field is blank.
    CMD: Command shutdown by HiRDB error detection
    FLT: Error shutdown
  35. Code indicating the cause of the shutdown of the corresponding RDAREA. For details about the shutdown cause code, see 15.3.1(2)(a) For an RDAREA other than a LOB RDAREA.
  36. Shutdown time of the corresponding RDAREA. If there is no history, this field is blank.
  37. Whether or not the RDAREA is in frozen update status:
    Y: Placed in frozen update status by the pddbfrz command.
    N: Not placed in frozen update status by the pddbfrz command.
  38. Whether or not the HiRDB files constituting the RDAREA are in frozen update status:
    U:
    Not in frozen update status. During backup, such HiRDB files need to be backed up.
    F:
    In the frozen update status. If a backup was made subsequent to the displayed date and time, there is no need to back up these HiRDB files again.
  39. Date and time the frozen update status was changed.
    When ****/**/** **:**:** is displayed:
    This information is displayed if the RDAREA has never been placed in frozen update status since it was created or re-initialized.
    Other that the above:
    The displayed information indicates the date and time the RDAREA was placed in frozen update status or released from frozen update status.
Note 1
Nos. 10-11 and 15-19 are not displayed for a LOB RDAREA.
Note 2
Nos. 27-29 and 37 are displayed for a LOB RDAREA.
Note 3
Nos. 30-32 are displayed when HiRDB Staticizer Option is used. If a generation is specified for analysis and the specified replica RDAREA generation does not exist, the utility issues a warning message, in which case no results are displayed.
1 The title bar is displayed when the -h option is specified.
2 When the output format is character string, this information is enclosed in double quotation marks (""), in which case the maximum length does not include the double quotation marks. When the output format is not character string, the information is not enclosed in double quotation marks.
3 This information is displayed only for a LOB RDAREA. For any other type of RDAREA, no data is output (example: ...,,...).
4 This information is displayed only when HiRDB Staticizer Option is used. When HiRDB Staticizer Option is not used, no data is displayed (example: ...,,...).
5 If the RDAREA has never been shut down, no data is output (example: ...,,...).

(3) Analyzing the analysis results

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 RDAREADescription
Entire RDAREAUnused segmentsManyThere is sufficient capacity.
FewUsed free pagesManyThe 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
FewThere is not enough capacity. Extend the RDAREA.2
1 For details about table and index reorganization, see Chapter 8. Database Reorganization Utility (pdrorg). For details about releasing free table and index pages, see Chapter 11. Free Page Release Utility (pdreclaim).
2 For details about RDAREA expansion, see Chapter 7. Database Structure Modification Utility (pdmod).

A user LOB RDAREA can be analyzed as follows:

Note
If an RDAREA storing the LOB attribute of a plug-in-provided abstract data type or an RDAREA storing a plug-in index is analyzed, the percentage of used segments in the RDAREA depends on the method used by the plug-in to allocate segments. For example, if a plug-in completes allocation of segments during index definition, most of the segments may become used segments immediately upon definition (before data is stored).
1 For details about RDAREA expansion, see Chapter 7. Database Structure Modification Utility (pdmod).
2 For details about table and index reorganization, see Chapter 8. Database Reorganization Utility (pdrorg).