Nonstop Database, HiRDB Version 9 System Operation Guide

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

27.9 Global buffer table (hirBufferStatusTable)

The global buffer table stores performance information collected over a given time period on global buffers. One line is created for each global buffer.

Notes on collecting performance information
Set the performance information collection interval to no less than 60 seconds so that HiRDB performance is not affected adversely.

The following table shows the configuration of the global buffer table.

Table 27-7 Configuration of the global buffer table

ID Object Explanation Type Privilege Data source
6. hirBufferStatusTable Global buffer table SEQUENCE not-access --
6.1 hirBufferStatusEntry Global buffer entry SEQUENCE not-access --
6.1.1 hirBufferStatusSysIndex HiRDB system identifier index INTEGER read-only MIB command
6.1.2 hirBufferStatusBufferIndex Global buffer identifier index INTEGER read-only MIB command
6.1.3 hirBufferStatusInstance Instance name
HiRDB-identifier:server-name:global-buffer-name
Display String read-only MIB command
6.1.4 hirBufferStatusHirID HiRDB identifier Display String read-only MIB command
6.1.5 hirBufferStatusBufferName Global buffer name Display String read-only pdbufls -k sts -d
6.1.6 hirBufferStatusBufferPoolHitRate Global buffer pool hit rate (%) INTEGER read-only pdbufls -k sts -d
6.1.7 hirBufferStatusCurrentReferenceBuffers Current number of reference buffers INTEGER read-only pdbufls -k sts -d
6.1.8 hirBufferStatusCurrentUpdateBuffers Current number of update buffers INTEGER read-only pdbufls -k sts -d
6.1.9 hirBufferStatusDBSyncs Number of synchronization points that have occurred Gauge read-only pdbufls -k sts -d
6.1.10 hirBufferStatusLOBBufferInputPages Number of LOB buffer batch input pages Gauge read-only pdbufls -k sts -d
6.1.11 hirBufferStatusLOBBufferOutputPages Number of LOB buffer batch output pages Gauge read-only pdbufls -k sts -d
6.1.12 hirBufferStatusLOBBufferReadRequests Number of LOB buffer read requests Gauge read-only pdbufls -k sts -d
6.1.13 hirBufferStatusLOBBufferWriteRequests Number of LOB buffer write requests Gauge read-only pdbufls -k sts -d
6.1.14 hirBufferStatusOutOfBuffer Number of times buffer shortage occurred Gauge read-only pdbufls -k sts -d
6.1.15 hirBufferStatusPrefetchBufferShortages Number of times prefetch buffer shortage occurred Gauge read-only pdbufls -k sts -d
6.1.16 hirBufferStatusPrefetchHitRate Prefetch hit rate (%) INTEGER read-only pdbufls -k sts -d
6.1.17 hirBufferStatusPrefetchInputPages Number of prefetch input pages Gauge read-only pdbufls -k sts -d
6.1.18 hirBufferStatusPrefetchReadRequests Number of prefetch read requests Gauge read-only pdbufls -k sts -d
6.1.19 hirBufferStatusReads Number of real read requests from disk Gauge read-only pdbufls -k sts -d
6.1.20 hirBufferStatusReferenceBufferFlushes Number of reference buffer flushes Gauge read-only pdbufls -k sts -d
6.1.21 hirBufferStatusReferenceGets Number of reference GETs Gauge read-only pdbufls -k sts -d
6.1.22 hirBufferStatusReferenceHitRate Reference request hit rate INTEGER read-only pdbufls -k sts -d
6.1.23 hirBufferStatusServerName Server name Display String read-only pdbufls -k sts -d
6.1.24 hirBufferStatusUpdateBufferFlushes Number of update buffer flushes Gauge read-only pdbufls -k sts -d
6.1.25 hirBufferStatusUpdateGets Number of update GETs Gauge read-only pdbufls -k sts -d
6.1.26 hirBufferStatusUpdateHitRate Update request hit rate (%) INTEGER read-only pdbufls -k sts -d
6.1.27 hirBufferStatusUpdatedBufferTrigger Number of update buffers that become output triggers during deferred write triggers INTEGER read-only pdbufls -k sts -d
6.1.28 hirBufferStatusWaits Number of times buffer lock-release wait occurred Gauge read-only pdbufls -k sts -d
6.1.29 hirBufferStatusWrites Number of real write operations to disk Gauge read-only pdbufls -k sts -d
6.1.30 hirBufferStatusDummy Cannot be referenced. INTEGER read-only MIB command

Legend:
--: Not applicable