26.8 RDAREA details table (hirRdareaDetStatusTable)

The RDAREA details table stores performance information collected over a given time period on RDAREAs. One line is created for each RDAREA.

Notes on collecting performance information
  • Set the performance information collection interval to not less than 3600 seconds so that HiRDB performance is not affected adversely.
  • For a shared RDAREA, the performance information of updatable back-end servers only is collected.
  • If the pddbst command cannot be executed, 0 (for a numeric value field) or a blank (for a character string field) is set in any field that acquires data from the pddbst command.
    The pddbst command can be executed when both the following conditions are satisfied:
    [Figure]The target RDAREA is a data dictionary RDAREA, user RDAREA, LOB RDAREA, registry RDAREA, or registry LOB RDAREA.
    [Figure]The target RDAREA is open without shutdown or referencing-possible hold in effect.

Table 26-6 shows the configuration of the RDAREA details table.

Table 26-6 Configuration of the RDAREA details table

IDObjectExplanationTypePrivilegeData source
5.hirRdareaDetStatusTableRDAREA details tableSEQUENCEnot-access[Figure]
5.1hirRdareaDetStatusEntryRDAREA details entrySEQUENCEnot-access[Figure]
5.1.1hirRdareaDetStatusSysIndexHiRDB system identifier indexINTEGERread-onlyMIB command
5.1.2hirRdareaDetStatusRdareaIndexRDAREA identifier indexINTEGERread-onlyMIB command
5.1.3hirRdareaDetStatusInstanceInstance name
HiRDB-identifier:server-name:RDAREA-name
Display
String
read-onlyMIB command
5.1.4hirRdareaDetStatusHirIDHiRDB identifierDisplay
String
read-onlyMIB command
5.1.5hirRdareaDetStatusAutoExtendErrorCodeError code when automatic extension cannot be executedINTEGERread-onlypddbst -k phys -f
5.1.6hirRdareaDetStatusAutoExtendStatusAutomatic extension facility's status:
SUP: Suppressed
NOSUP: Not suppressed
Display
String
read-onlypddbst -k phys -f
5.1.7hirRdareaDetStatusAutoExtendUseAutomatic extension facility's use status:
USE: Being used
NOUSE: Not being used
Display
String
read-onlypddbst -k phys -f
5.1.8hirRdareaDetStatusBufferNameGlobal buffer nameDisplay
String
read-onlypdbufls -k def-s SERVR_NAME
5.1.9hirRdareaDetStatusExtensionSegmentSizeNumber of segment extensions
0 if RDAREA extension is not specified.
INTEGERread-onlyDictionary table1
5.1.10hirRdareaDetStatusFileCountNumber of HiRDB filesINTEGERread-onlyDictionary table1
5.1.11hirRdareaDetStatusFreezeSpecifiedWhether or not RDAREA updating is frozenDisplay
String
read-onlypddbst -k phys -f2
5.1.12hirRdareaDetStatusFullUsedPageRatio of full pages (%)INTEGERread-onlypddbst -k phys -f9
5.1.13hirRdareaDetStatusFullUsedPagesNumber of full pagesINTEGERread-onlypddbst -k phys -f9
5.1.14hirRdareaDetStatusGenNumberGeneration number of the RDAREAINTEGERread-onlypddbst -k phys -f4
5.1.15hirRdareaDetStatusHoldCode1Hold cause code for the RDAREAINTEGERread-onlypddbst -k phys -f
5.1.16hirRdareaDetStatusHoldCode2Hold cause code immediately prior to Hold Status 1INTEGERread-onlypddbst -k phys -f
5.1.17hirRdareaDetStatusHoldStatus1Hold type of the RDAREA:
1: Error shutdown (shut down by an error)
2: Command shutdown (command shutdown based on error detection by HiRDB)
3: Value output by pddbst (value other than FLT or CMD)
4: Blank (other cases)
Display
String
read-onlypddbst -k phys -f
5.1.18hirRdareaDetStatusHoldStatus2Hold status immediately prior to Hold Status 1Display
String
read-onlypddbst -k phys -f
5.1.19hirRdareaDetStatusHoldTime1Hold time of the RDAREADisplay
String
read-onlypddbst -k phys -f
5.1.20hirRdareaDetStatusHoldTime2Hold time immediately prior to Hold Status 1Display
String
read-onlypddbst -k phys -f
5.1.21hirRdareaDetStatusIndexCountNumber of stored indexes (number defined)INTEGERread-onlyDictionary table1
5.1.22hirRdareaDetStatusLastSegmentPosition information indicating the last segment being used
Always indicates the last segment if Segment Over is Y.
INTEGERread-onlypddbst -k phys -f6
5.1.23hirRdareaDetStatusLobmapOverWhether or not all LOB management entries are being used:
Y: All are being used
N: Some entries are unused
Display
String
read-onlypddbst -k phys -f5
5.1.24hirRdareaDetStatusOriginal
RDAREAName
Original RDAREA nameDisplay
String
read-onlypddbst -k phys -f3
5.1.25hirRdareaDetStatusPageSizePage size (bytes)INTEGERread-onlyDictionary table1
5.1.26hirRdareaDetStatusRDAREANameRDAREA nameDisplay
String
read-onlypddbls -r ALL -a
5.1.27hirRdareaDetStatusRDAREAStatusRDAREA status
One of the following:
CLOSE, CLOSE HOLD, CLOSE HOLD (INQ), CLOSE HOLD (CMD), CLOSE HOLD (BU), CLOSE HOLD (BU I), CLOSE HOLD (BU W), CLOSE HOLD (BU IW), CLOSE HOLD (SYNC), CLOSE HOLD (ORG), CLOSE ACCEPT-HOLD, HOLD, HOLD (INQ), HOLD (CMD), HOLD (BU), HOLD (BU I), HOLD (BU W), HOLD (BU IW), HOLD (SYNC), HOLD (ORG), ACCEPT-HOLD, OPEN
Display
String
read-onlypddbls -r ALL -a
5.1.28hirRdareaDetStatusRDAREATypeRDAREA type
One of the following:
MAST, DDIR, DDIC, DLOB, USER, ULOB, LIST, RGST, RLOB
Display
String
read-onlypddbls -r ALL -a
5.1.29hirRdareaDetStatusReplicaRDAREAsNumber of replica RDAREAsINTEGERread-onlypddbst -k phys -f4
5.1.30hirRdareaDetStatusSegmentOverWhether or not LOB RDAREA storage is disorganized:
Y: Disorganized
N: Organized
Display
String
read-onlypddbst -k phys -f5
5.1.31hirRdareaDetStatusSegmentSizeSegment sizeINTEGERread-onlyDictionary table1
5.1.32hirRdareaDetStatusServerNameServer nameDisplay
String
read-onlypddbls -r ALL -a
5.1.33hirRdareaDetStatusTableCountNumber of stored tables (number defined)INTEGERread-onlyDictionary table1
5.1.34hirRdareaDetStatusTotalPagesTotal number of pages in segments in the RDAREA (number-of-used-pages + number-of-unused-pages)INTEGERread-onlypddbst -k phys -f10
5.1.35hirRdareaDetStatusTotalRDAREASegmentsTotal number of segments in the RDAREAINTEGERread-onlypddbls -r ALL -a
5.1.36hirRdareaDetStatusUnusedRDAREASegmentsNumber of unused segments in the RDAREAINTEGERread-onlypddbls -r ALL -a
5.1.37hirRdareaDetStatusUsedRate of used segmentsINTEGERread-onlyFixed to 0
5.1.38hirRdareaDetStatusUsedPagePercentage of used pages (%)INTEGERread-onlypddbst -k phys -f8
5.1.39hirRdareaDetStatusUsedPagesNumber of used pagesINTEGERread-onlypddbst -k phys -f7
5.1.40hirRdareaDetStatusDummyCannot be referenced.INTEGERread-onlyMIB command

Legend:

[Figure]: Not applicable

1 Result of the following SQL statement:

SELECT PAGE_SIZE,SEGMENT_SIZE,FILE_COUNT,N_TABLE,N_INDEX,EXTENSION_SEGMENT_SIZE FROM "MASTER".SQL_RDAREAS

2 Left blank except in the case of a LOB RDAREA.
3 Left blank if HiRDB Staticizer Option is not installed.
4 0 if HiRDB Staticizer Option is not installed.
5 Left blank except in the case of a LOB RDAREA.
6 0 except in the case of a LOB RDAREA.
7 Value of USED_AREA_SEG in the case of a LOB RDAREA.
8 Value of PERCENT_USED in the case of a LOB RDAREA.
9 0 in the case of a LOB RDAREA.
10 Value of TOTAL_AREA_SEG in the case of a LOB RDAREA.