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.

The following table shows the configuration of the RDAREA table.

Table 27-5 Configuration of the RDAREA table

ID	Object	Explanation	Type	Privilege	Data source
4.	hirRdareaStatusTable	RDAREA table	SEQUENCE	not-access	--
4.1	hirRdareaStatusEntry	RDAREA entry	SEQUENCE	not-access	--
4.1.1	hirRdareaStatusSysIndex	HiRDB system identifier index	INTEGER	read-only	MIB command
4.1.2	hirRdareaStatusRdareaIndex	RDAREA identifier index	INTEGER	read-only	MIB command
4.1.3	hirRdareaStatusInstance	Instance name HiRDB-identifier:server-name:RDAREA-name	Display String	read-only	MIB command
4.1.4	hirRdareaStatusHirID	HiRDB identifier	Display String	read-only	MIB command
4.1.5	hirRdareaStatusBufferName	Global buffer name	Display String	read-only	pdbufls -k def-s SERVR_NAME
4.1.6	hirRdareaStatusExtensionSegmentSize	Number of segment extensions 0 if RDAREA extension is not specified.	INTEGER	read-only	Dictionary table#
4.1.7	hirRdareaStatusFileCount	Number of HiRDB files	INTEGER	read-only	Dictionary table#
4.1.8	hirRdareaStatusIndexCount	Number of stored indexes (number defined)	INTEGER	read-only	Dictionary table#
4.1.9	hirRdareaStatusPageSize	Page size (bytes)	INTEGER	read-only	Dictionary table#
4.1.10	hirRdareaStatusRDAREAName	RDAREA name	Display String	read-only	pddbls -r ALL -a
4.1.11	hirRdareaStatusRDAREAStatus	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
4.1.12	hirRdareaStatusRDAREAType	RDAREA type One of the following: MAST, DDIR, DDIC, DLOB, USER, ULOB, LIST, RGST, RLOB	Display String	read-only	pddbls -r ALL -a
4.1.13	hirRdareaStatusSegmentSize	Segment size (pages)	INTEGER	read-only	Dictionary table#
4.1.14	hirRdareaStatusServerName	Server name	Display String	read-only	pddbls -r ALL -a
4.1.15	hirRdareaStatusTableCount	Number of stored tables (number defined)	INTEGER	read-only	Dictionary table#
4.1.16	hirRdareaStatusTotalRDAREASegments	Total number of segments in the RDAREA	INTEGER	read-only	pddbls -r ALL -a
4.1.17	hirRdareaStatusUnusedRDAREASegments	Number of unused segments in the RDAREA	INTEGER	read-only	pddbls -r ALL -a
4.1.18	hirRdareaStatusDummy	Cannot be referenced.	INTEGER	read-only	MIB command

Legend:

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