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 3,600 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:
The target RDAREA is a data dictionary RDAREA, user RDAREA, LOB RDAREA, registry RDAREA, or registry LOB RDAREA.
The target RDAREA is open without shutdown or referencing-possible hold in effect.

The following table shows the configuration of the RDAREA details table.

Table 27-6 Configuration of the RDAREA details table

ID	Object	Explanation	Type	Privilege	Data source
5.	hirRdareaDetStatusTable	RDAREA details table	SEQUENCE	not-access	--
5.1	hirRdareaDetStatusEntry	RDAREA details entry	SEQUENCE	not-access	--
5.1.1	hirRdareaDetStatusSysIndex	HiRDB system identifier index	INTEGER	read-only	MIB command
5.1.2	hirRdareaDetStatusRdareaIndex	RDAREA identifier index	INTEGER	read-only	MIB command
5.1.3	hirRdareaDetStatusInstance	Instance name HiRDB-identifier:server-name:RDAREA-name	Display String	read-only	MIB command
5.1.4	hirRdareaDetStatusHirID	HiRDB identifier	Display String	read-only	MIB command
5.1.5	hirRdareaDetStatusAutoExtendErrorCode	Error code when automatic extension cannot be executed	INTEGER	read-only	pddbst -k phys -f
5.1.6	hirRdareaDetStatusAutoExtendStatus	Automatic extension facility's status: SUP: Suppressed NOSUP: Not suppressed	Display String	read-only	pddbst -k phys -f
5.1.7	hirRdareaDetStatusAutoExtendUse	Automatic extension facility's use status: USE: Being used NOUSE: Not being used	Display String	read-only	pddbst -k phys -f
5.1.8	hirRdareaDetStatusBufferName	Global buffer name	Display String	read-only	pdbufls -k def-s SERVR_NAME
5.1.9	hirRdareaDetStatusExtensionSegmentSize	Number of segment extensions 0 if RDAREA extension is not specified.	INTEGER	read-only	Dictionary table^#¹
5.1.10	hirRdareaDetStatusFileCount	Number of HiRDB files	INTEGER	read-only	Dictionary table^#¹
5.1.11	hirRdareaDetStatusFreezeSpecified	Whether RDAREA updating is frozen	Display String	read-only	pddbst -k phys -f^#²
5.1.12	hirRdareaDetStatusFullUsedPage	Ratio of full pages (%)	INTEGER	read-only	pddbst -k phys -f^#⁹
5.1.13	hirRdareaDetStatusFullUsedPages	Number of full pages	INTEGER	read-only	pddbst -k phys -f^#⁹
5.1.14	hirRdareaDetStatusGenNumber	Generation number of the RDAREA	INTEGER	read-only	pddbst -k phys -f^#⁴
5.1.15	hirRdareaDetStatusHoldCode1	Hold cause code for the RDAREA	INTEGER	read-only	pddbst -k phys -f
5.1.16	hirRdareaDetStatusHoldCode2	Hold cause code immediately prior to Hold Status 1	INTEGER	read-only	pddbst -k phys -f
5.1.17	hirRdareaDetStatusHoldStatus1	Hold 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-only	pddbst -k phys -f
5.1.18	hirRdareaDetStatusHoldStatus2	Hold status immediately prior to Hold Status 1	Display String	read-only	pddbst -k phys -f
5.1.19	hirRdareaDetStatusHoldTime1	Hold time of the RDAREA	Display String	read-only	pddbst -k phys -f
5.1.20	hirRdareaDetStatusHoldTime2	Hold time immediately prior to Hold Status 1	Display String	read-only	pddbst -k phys -f
5.1.21	hirRdareaDetStatusIndexCount	Number of stored indexes (number defined)	INTEGER	read-only	Dictionary table^#¹
5.1.22	hirRdareaDetStatusLastSegment	Position information indicating the last segment being used Always indicates the last segment if Segment Over is Y.	INTEGER	read-only	pddbst -k phys -f^#⁶
5.1.23	hirRdareaDetStatusLobmapOver	Whether all LOB management entries are being used: Y: All are being used N: Some entries are unused	Display String	read-only	pddbst -k phys -f^#⁵
5.1.24	hirRdareaDetStatusOriginalRDAREAName	Original RDAREA name	Display String	read-only	pddbst -k phys -f^#³
5.1.25	hirRdareaDetStatusPageSize	Page size (bytes)	INTEGER	read-only	Dictionary table^#¹
5.1.26	hirRdareaDetStatusRDAREAName	RDAREA name	Display String	read-only	pddbls -r ALL -a
5.1.27	hirRdareaDetStatusRDAREAStatus	RDAREA 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-only	pddbls -r ALL -a
5.1.28	hirRdareaDetStatusRDAREAType	RDAREA type One of the following: MAST, DDIR, DDIC, DLOB, USER, ULOB, LIST, RGST, RLOB	Display String	read-only	pddbls -r ALL -a
5.1.29	hirRdareaDetStatusReplicaRDAREAs	Number of replica RDAREAs	INTEGER	read-only	pddbst -k phys -f^#⁴
5.1.30	hirRdareaDetStatusSegmentOver	Whether LOB RDAREA storage is disorganized: Y: Disorganized N: Organized	Display String	read-only	pddbst -k phys -f^#⁵
5.1.31	hirRdareaDetStatusSegmentSize	Segment size	INTEGER	read-only	Dictionary table^#¹
5.1.32	hirRdareaDetStatusServerName	Server name	Display String	read-only	pddbls -r ALL -a
5.1.33	hirRdareaDetStatusTableCount	Number of stored tables (number defined)	INTEGER	read-only	Dictionary table^#¹
5.1.34	hirRdareaDetStatusTotalPages	Total number of pages in segments in the RDAREA (number-of-used-pages + number-of-unused-pages)	INTEGER	read-only	pddbst -k phys -f^#¹⁰
5.1.35	hirRdareaDetStatusTotalRDAREASegments	Total number of segments in the RDAREA	INTEGER	read-only	pddbls -r ALL -a
5.1.36	hirRdareaDetStatusUnusedRDAREASegments	Number of unused segments in the RDAREA	INTEGER	read-only	pddbls -r ALL -a
5.1.37	hirRdareaDetStatusUsed	Rate of used segments	INTEGER	read-only	Fixed to 0
5.1.38	hirRdareaDetStatusUsedPage	Percentage of used pages (%)	INTEGER	read-only	pddbst -k phys -f^#⁸
5.1.39	hirRdareaDetStatusUsedPages	Number of used pages	INTEGER	read-only	pddbst -k phys -f^#⁷
5.1.40	hirRdareaDetStatusDummy	Cannot be referenced.	INTEGER	read-only	MIB command

Legend:: --: 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.

27.8 RDAREA details table (hirRdareaDetStatusTable)