Nonstop Database, HiRDB Version 9 System Operation Guide

[Contents][Index][Back][Next]

27.10 HiRDB file system area (RDAREAs) table (hirRdareaFileTable)

The HiRDB file system area (RDAREAs) table stores performance information collected over a given time period on a HiRDB file system area for RDAREAs. One line is created for each combination of a HiRDB file system area and an RDAREA.

Notes on collecting performance information
  • Performance information is collected while HiRDB statistical information is being collected.
    Trigger for starting statistical information collection
    [Figure] When the pdstbegin command is executed with fil specified for the statistical information type (-k option) while HiRDB is running
    [Figure] When HiRDB is started by the pdstbegin operand with fil specified for the statistical information type (-k option)
    Trigger for terminating statistical information collection
    [Figure] When the pdstend command is executed while HiRDB is running
    [Figure] When HiRDB is terminated
  • For a shared RDAREA, performance information is collected for each server on a separate line.
  • Performance information cannot be collected on a unit that is stopped.

The following table shows the configuration of the HiRDB file system area (RDAREAs) table.

Table 27-8 Configuration of the HiRDB file system area (RDAREAs) table

ID Object Explanation Type Privilege Data source
9. hirRdareaFileTable HiRDB file system area (RDAREAs) table SEQUENCE not-access --
9.1 hirRdareaFileEntry HiRDB file system area entry SEQUENCE not-access --
9.1.1 hirRdareaFileSysIndex HiRDB system identifier index INTEGER read-only MIB command
9.1.2 hirRdareaFileServerIndex Server identifier index INTEGER read-only MIB command
9.1.3 hirRdareaFileFileIndex HiRDB file identifier index INTEGER read-only MIB command
9.1.4 hirRdareaFileRdareaIndex RDAREA identifier index INTEGER read-only MIB command
9.1.5 hirRdareaFileInstance Instance name
HiRDB-identifier:server-name:HiRDB-file-system-area-name:RDAREA
Display String read-only MIB command
9.1.6 hirRdareaFileHirID HiRDB identifier Display String read-only MIB command
9.1.7 hirRdareaFileAIORead System-specific information (AIO READ) INTEGER read-only pdstedit (fil)#1
9.1.8 hirRdareaFileAIOWrite System-specific information (AIO WRITE) INTEGER read-only pdstedit (fil)#1
9.1.9 hirRdareaFileClose Number of closing operations that occurred (CLOSE) INTEGER read-only pdstedit (fil)#1
9.1.10 hirRdareaFileFreeMBytes Size of unused area in the user area (area not allocated as HiRDB files)(KB) INTEGER read-only pdfstatfs FS_NAME
9.1.11 hirRdareaFileHiRDBFileSystemAreaName HiRDB file system area name (full path) (FS NAME) Display String read-only pdstedit (fil)#2
9.1.12 hirRdareaFileHiRDBFileSystemAreaType HiRDB file system area type (DB, DB(NOLOB), SVR) Display String read-only pdfstatfs FS_NAME
9.1.13 hirRdareaFileHost Host name (HOST) Display String read-only pdstedit (fil)
9.1.14 hirRdareaFileIOError Number of input/output errors (IO ERROR) INTEGER read-only pdstedit (fil)#1
9.1.15 hirRdareaFileListIO System-specific information (LIST IO) INTEGER read-only pdstedit (fil)#1
9.1.16 hirRdareaFileMbytes Total size of user areas in the HiRDB file system area (MB) INTEGER read-only pdfstatfs FS_NAME
9.1.17 hirRdareaFileOpen Number of opening operations that occurred (OPEN) INTEGER read-only pdstedit (fil)#1
9.1.18 hirRdareaFileRDAREAName RDAREA name (RDAREA NAME) Display String read-only pdstedit (fil)
9.1.19 hirRdareaFileServerName Server name (SERVER NAME) Display String read-only pdstedit (fil)
9.1.20 hirRdareaFileSyncRead Number of synchronous read operations that occurred (SYNC READ) INTEGER read-only pdstedit (fil)#1
9.1.21 hirRdareaFileSyncWrite Number of synchronous write operations that occurred (SYNC WRITE) INTEGER read-only pdstedit (fil)#1
9.1.22 hirRdareaFileDummy Cannot be referenced. INTEGER read-only MIB command

Legend:
--: Not applicable

Note: Information in parentheses following pdstedit is the edit item in the statistics analysis utility.

#1: Operations are separated into groups based on the combination of RDAREA NAME and HiRDB file system area name obtained by removing the HiRDB file name from HOST, SERVER, and FILE NAME in fil_DAT in order to compute the total of the numeric value data in the fields. Overflow is indicated when ********** is output instead of numeric data, and 0 is set.

#2: Created by removing the HiRDB file name from the full-path HiRDB file name. For example, /users/hirdb_s/area/rdsys04 is obtained from /users/hirdb_s/area/rdsys04/rddata01.