26.7 RDAREA table (hirRdareaStatusTable)

The RDAREA 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 600 seconds so that HiRDB performance is not affected adversely.
  • For a shared RDAREA, performance information of updatable back-end servers only is collected.

Table 26-5 shows the configuration of the RDAREA table.

Table 26-5 Configuration of the RDAREA table

IDObjectExplanationTypePrivilegeData source
4.hirRdareaStatusTableRDAREA tableSEQUENCEnot-access[Figure]
4.1hirRdareaStatusEntryRDAREA entrySEQUENCEnot-access[Figure]
4.1.1hirRdareaStatusSysIndexHiRDB system identifier indexINTEGERread-onlyMIB command
4.1.2hirRdareaStatusRdareaIndexRDAREA identifier indexINTEGERread-onlyMIB command
4.1.3hirRdareaStatusInstanceInstance name
HiRDB-identifier:server-name:RDAREA-name
Display
String
read-onlyMIB command
4.1.4hirRdareaStatusHirIDHiRDB identifierDisplay
String
read-onlyMIB command
4.1.5hirRdareaStatusBufferNameGlobal buffer nameDisplay
String
read-onlypdbufls -k def-s SERVR_NAME
4.1.6hirRdareaStatusExtensionSegmentSizeNumber of segment extensions
0 if RDAREA extension is not specified.
INTEGERread-onlyDictionary table*
4.1.7hirRdareaStatusFileCountNumber of HiRDB filesINTEGERread-onlyDictionary table*
4.1.8hirRdareaStatusIndexCountNumber of stored indexes (number defined)INTEGERread-onlyDictionary table*
4.1.9hirRdareaStatusPageSizePage size (bytes)INTEGERread-onlyDictionary table*
4.1.10hirRdareaStatusRDAREANameRDAREA nameDisplay
String
read-onlypddbls -r ALL -a
4.1.11hirRdareaStatusRDAREAStatusRDAREA 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
4.1.12hirRdareaStatusRDAREATypeRDAREA type
One of the following:
MAST, DDIR, DDIC, DLOB, USER, ULOB, LIST, RGST, RLOB
Display
String
read-onlypddbls -r ALL -a
4.1.13hirRdareaStatusSegmentSizeSegment size (pages)INTEGERread-onlyDictionary table*
4.1.14hirRdareaStatusServerNameServer nameDisplay
String
read-onlypddbls -r ALL -a
4.1.15hirRdareaStatusTableCountNumber of stored tables (number defined)INTEGERread-onlyDictionary table*
4.1.16hirRdareaStatusTotalRDAREASegmentsTotal number of segments in the RDAREAINTEGERread-onlypddbls -r ALL -a
4.1.17hirRdareaStatusUnusedRDAREASegmentsNumber of unused segments in theRDAREAINTEGERread-onlypddbls -r ALL -a
4.1.18hirRdareaStatusDummyCannot be referenced.INTEGERread-onlyMIB command

Legend:

[Figure]: Not applicable

* Result of the following SQL statement:

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