2.9 pdbufls (Display global buffer information)

Organization of this section
(1) Function
(2) Executor
(3) Format
(4) Options
(5) Rules
(6) Notes
(7) Output format

(1) Function

The pdbufls command displays the status of global buffers.

If there are in-memory RDAREAs, this command can also display the status of the in-memory data buffers.

(2) Executor

HiRDB administrator

(3) Format

pdbufls [-k output-type][-d] [-x [-y]] [-M][-N]
        [{-s server-name[,server-name]...
          | -a global-buffer-name[,global-buffer-name]...}]
        [-W execution-monitoring-interval]

(4) Options

(a) -k output-type ~<<sts>>

Specifies the type of information to be displayed:

def
Global buffer definition information.
sts
Global buffer statistical information. The statistical information accumulated since the last time the pdbufls command was executed is displayed. The first time you execute the pdbufls command, or if you specify the -d option, the system displays the statistical information accumulated since HiRDB started.
all
Both global buffer definition information and statistical information.
(b) -s server-name ~<identifier> ((1-8))

Specifies a server name in order to display information about all global buffers at that server. A maximum of 128 server names that can be specified; subsequent server name specifications are ignored.

(c) -a global-buffer-name ~<identifier> ((1-16))

Specifies the name of a global buffer for which information is be displayed. If duplicate global buffer names are specified, the duplications are eliminated. A maximum of 128 global buffer names can be specified; subsequent global buffer name specifications are ignored.

If an in-memory data buffer name is specified in this option, the command displays information about the in-memory data buffer.

(d) -d

Specifies that the system is to display the statistical information about a global buffer since HiRDB started. If-k def is specified, the system ignores this option, if specified.

(e) -x

Specifies that the information is to be displayed in DAT format. When -k all is specified, this option cannot be specified.

(f) -y

When the -x option is specified, specifies that a header is to be displayed.

(g) -M

Specifies that in-memory data buffer information is to be displayed. The following shows specification examples of this option.

Specification example 1:
pdbufls -k def -M
The command displays both global buffer information and in-memory data buffer information.
Specification example 2:
pdbufls -k sts -M -a in-memory-data-buffer-name
The command displays statistical information about the in-memory data buffer specified in the -a option.

In-memory data buffer information is displayed in the same manner as global buffer information. Therefore, when you display in-memory data buffer information by specifying this option, replace global buffer with in-memory data buffer in the description of the pdbufls command.

(h) -N

Specifies that the names of the RDAREAs allocated to the OTHER global buffer are to be displayed. If sts is specified in the -k option or if the -k option is omitted, this option is ignored.

(i) -W execution-monitoring-interval ~<unsigned integer> ((0 to 3600))

Specifies (in minutes) the monitoring interval when the execution time of the pdbufls command is to be monitored. For guidelines on the value to specify and details about the resulting operation, see the description of the pd_cmd_exec_time operand in the system common definition in the manual HiRDB Version 9 System Definition.

If 0 is specified in this option, the command's execution time is not monitored.

If this option is omitted, the value of the pd_cmd_exec_time operand in the system common definition takes effect.

(5) Rules

  1. The pdbufls command can be executed only while HiRDB is active.
  2. The pdbufls command must be executed at the server machine containing the single server or the server machine where the system manager is located.
  3. If the -s and -a options are both omitted, global buffer information for all servers is displayed
  4. The figure below shows the collection range for global buffer statistical information.

    Figure 2-1 Collection range of global buffer statistical information

    [Figure]

Explanation
  1. The range of information to be displayed is A, which is from HiRDB startup to 1. In this case, the previous statistical information collection time is not displayed.
  2. Because the -d option is specified, the system displays the information in the range A + B, which is from HiRDB startup to 2. In this case, the previous statistical information collection time is not displayed. This global buffer information does not take effect on the next pdbufls command.
  3. The information displayed with buf01 is in the range B + C, which is from 1 through 3. The information displayed with buf02 is in the range of D, which is from HiRDB startup to 3. For buf01, the statistical information collection time of 1 above is displayed; for buf02, the previous statistical information collection time is not displayed.

(6) Notes

  1. The following are the pdbufls command's return codes:
    0: Normal termination
    4: Warning termination (some server processing terminated with an error)
    8: Abnormal termination
    12: Abnormal termination (an event occurred that prevented output of an error message)
    When the return code is 12, check the error message in syslogfile at the host where the single server or dictionary server is located, eliminate the cause of the error, and then re-execute the pdbufls command. If no error message was output to syslogfile, contact the customer engineer.
  2. If a global buffer whose total number of reference GETs and update GETs exceeds 4,294,967,295 is detected, statistical information collection for that global buffer is reset. Such a reset occurs at the following times:
    • When pdbufls -k sts or pdbufls -k all is executed (including being executed internally by JP1/PFM-Agent for HiRDB).
    • When a synchronization point occurs while statistical log information is being collected by pdstbegin -k buf
    The figure below shows reset times and the statistical information that is acquired at a reset.

    Figure 2-2 Reset times for global buffer statistical information and the statistical information that is acquired at a reset

    [Figure]

Explanation
  • Reset occurs at point A
    All the information items for display at point A are 0 except for the following:
    [Figure]Number of current reference buffers
    [Figure]Number of current update buffers
    [Figure]Number of update buffers for the next time output of a deferred write trigger occurs
    The information items displayed at point B are for period a.
    The information items displayed at point C are for period b among the statistical log information that is output at point C.
  • Reset occurs at point B
    All the information items for display at point B are 0 except for the following:
    [Figure]Number of current reference buffers
    [Figure]Number of current update buffers
    [Figure]Number of update buffers for the next time output of a deferred write trigger occurs
    The information items displayed at point C are for period c among the statistical log information that is output at point C.
    The information items displayed at point D are for period d.
  • Reset occurs at point C
    All the information items for display at point C are 0 except for the following:
    [Figure]Buffer sector count
    [Figure]Number of current reference buffers
    [Figure]Number of current update buffers
    [Figure]Number of update buffers for the next time output of a deferred write trigger occurs
    [Figure]Number of lock release waits during lock processing on the buffer management area
    [Figure]Percentage of buffer contention-lock release waits resulting from buffer lock processing
    [Figure]Average sleep processing execution count of buffer lock processing
    [Figure]Percentage of buffer lock processing in spin processing
    [Figure]Average spin loop execution count during buffer lock processing
    [Figure]Buffer pool lock exclusive time during synchronization point processing
    [Figure]Number of buffers processed within the buffer pool lock exclusive time during synchronization point processing
    The information items displayed at point D are for period e.

(7) Output format

(a) -k def specified

DEFINE OF GLOBAL BUFFER
 EDIT TIME aa...a
 BUFNAME SVID    TYPE   SIZE  NUM    WRATIO RDAREA/INDEX NAME
                 PRMAX  PRNUM CSIZE  MAPS
 bb...b  cc...c  d      eeK   ff...f ggg    hh...h
                 kk...k lll   mm...m nn...n
      [NOT FOUND ii...i=jj...j]

Explanation
aa...a
Time when pdbufls command was executed (year/month/date hour:minute:second).
bb...b
Global buffer name (up to 16 characters).
cc...c
Server name (up to 8 characters).
d
Global buffer type:
R: RDAREA
I: Index
B: LOB
O: Other
The O (Other) global buffer type means a global buffer for which the -o option is specified in the pdbuffer operand in the system common definition.
M: In-memory data buffer
ee
Buffer length (in KB; 2 decimal digits).
ff...f
Number of buffer sectors (1 to 6 decimal digits in the 32-bit mode; 1 to 10 decimal digits in the 64-bit mode).
ggg
Updated output pages at the time of deferred write trigger (percentage; 3 decimal digits). This is the value specified in the -w option in the pdbuffer operand in the system common definition.
hh...h
RDAREA name or index name (up to 65 characters).
If multiple RDAREAs are allocated to the same global buffer, multiple rows are displayed with one row for each allocated RDAREA. An RDAREA that has been deleted is not displayed.
If allocated indexes or all allocated RDAREAs have been deleted, this item is not displayed.
This item is not displayed if the OTHER global buffer satisfies either of the following conditions:
  • The -N option is omitted.
  • No RDAREA is allocated to the OTHER global buffer.
The output format is as follows:
RDAREA name: RDAREA-name
Index name: authorization-identifier.index-identifier
ii...i
SERVER when the -s option is specified; BUFFER POOL when the -a option is specified.
jj...j
Server name when the -s option is specified (up to 8 characters); global buffer name when the -a option is specified (up to 16 characters).
kk...k
Maximum number of concurrent prefetch operations (5 decimal digits). This is the value specified in the pdbuffer -m option in the system common definition.
lll
Maximum number of batch input pages (3 decimal digits). This is the value specified in the pdbuffer -p option in the system common definition.
mm...m
Internal information used by the system. ****** is always displayed.
nn...n
Internal information used by the system. ** is always displayed.
(b) -k sts specified

STATISTICS OF GLOBAL BUFFER
EDIT TIME aa...a
BUFFNAME SVID  HIT(REF,UPD)  RFGET  READ   RFFLS  REFBUF     WAITL
        LAST_EXEC_TIME      UPGET  WRITE  UPFLS  UPBUF(TRG) SYNC
                            PRRED  PRHIT  PRINS  PRREQ      INSB
                            LRREQ  LWREQ  LRPAG  LWPAG
                            CINSM  CFMAX  CFAVG
bb...b   cc...c eee(fff,ggg) hh...h jj...j ll...l nn...n......qq...q
        dd...d              ii...i kk...k mm...m oo...o(pp...p) rr...r
                            uu...u vvv    ww...w xx...x     yy...y
                            zz...z AA...A BB...B CC...C
                            DD...D EE...E FF...F
      [NOT  FOUND ss...s=tt...t]

Explanation
aa...a
Time when pdbufls command was executed (year/month/date hour:minute:second).
bb...b
Global buffer name (up to 16 characters).
cc...c
Server name (up to 8 characters).
dd...d
Last time statistical information was acquired for each global buffer (year/month/date hour:minute:second)
If no statistical information has been collected or if the -d option is specified, ****-**-** **:**:** is displayed.
eee
Hits rate for the global buffer (percentage; 3 decimal digits).
fff
Hits rate for referencing requests (percentage; 3 decimal digits).
ggg
Hits rate for updating requests (percentage; 3 decimal digits).
hh...hh
Number of reference GETs.#
ii...i
Number of update GETs.#
jj...j
Number of actual READs.#
kk...k
Number of actual WRITEs.#
ll...l
Number of reference buffer flushes.#
mm...m
Number of update buffer flushes.#
nn...n
Number of current reference buffers (1 to 6 decimal digits in the 32-bit mode; 1 to 10 decimal digits in the 64-bit mode).
oo...o
Number of current update buffers (1 to 6 decimal digits in the 32-bit mode; 1 to 10 decimal digits in the 64-bit mode).
pp...p
Number of update buffers for the next time output of a deferred write trigger occurs (1 to 6 decimal digits in the 32-bit mode; 1 to 10 decimal digits in the 64-bit mode).
qq...q
Number of times a wait for buffer lock release occurred.#
rr...r
Number of DB synchronization points.#
ss...s
SERVER when the -s option is specified; BUFFER POOL when the -a option is specified.
tt...t
Server name when the -s option is specified (up to 8 characters); global buffer name when the -a option is specified (up to 16 characters).
uu...u
Number of prefetch input pages.#
vvv
Prefetch hit range (3 decimal digits).
ww...w
Number of prefetch buffer shortages.#
xx...x
Number of prefetch READ requests.#
yy...y
Number of out of buffer errors.#
zz...z
Number of LOB buffer READ requests.#
AA...A
Number of LOB buffer WRITE requests.#
BB...B
Number of pages input into LOB buffer in batch.#
CC...C
Number of pages output from LOB buffer in batch.#
DD...D
Internal information used by the system.
EE...E
Internal information used by the system.
FF...F
Internal information used by the system.
#: The display format is as follows:
Numeric rangeDisplay format
0 to 9990 to 999
1,000 to 9,9941.00K to 9.99K#
9,995 to 99,94910.0K to 99.9K#
99,950 to 999,499100K to 999K#
999,500 to 9,994,9991.00M to 9.99M#
9,995,000 to 99,949,99910.0M to 99.9M#
99,950,000 to 999,499,999100M to 999M#
999,500,000 to 4,294,967,2951.00G to 4.29G#
Legend:
K: Kilo
M: Mega
G: Giga
#: Decimal places beyond the displayed digits are rounded off.
(c) DAT output format (when -x and -y options are specified)
Note
[CR] indicates a linefeed.
Explanation
For details about aa...a through FF...F, see the information above provided in (7) Output format. The items described below are displayed only in the DAT format.
GG...G:
Real data for reference GETs count (up to 10 decimal digits)
HH...H:
Real data for update GETs count (up to 10 decimal digits)
II...I:
Real data for reference request hits count (up to 10 decimal digits)
JJ...J:
Read data for update request hits count (up to 10 decimal digits)
KK...K:
Real data for real READs count (up to 10 decimal digits)
LL...L:
Real data for real WRITEs count (up to 10 decimal digits)
MM...M:
Real data for reference buffer flushes count (up to 10 decimal digits)
NN...N:
Real data for update buffer flushes count (up to 10 decimal digits)
OO...O:
Real data for buffer lock release waits count (up to 10 decimal digits)
PP...P:
Real data for database synchronization points count (up to 10 decimal digits)
QQ...Q:
Real data for prefetch input pages count (up to 10 decimal digits)
RR...R:
Real data for prefetch hits count (up to 10 decimal digits)
SS...S:
Real data for prefetch buffer shortages count (up to 10 decimal digits)
TT...T:
Real data for prefetch READ requests count (up to 10 decimal digits)
UU...U:
Real data for buffer shortages count (up to 10 decimal digits)
VV...V:
Real data for LOB buffer READ requests count (up to 10 decimal digits)
WW...W:
Real data for LOB buffer WRITE requests count (up to 10 decimal digits)
XX...X:
Real data for batch input pages count for LOB buffer (up to 10 decimal digits)
YY...Y:
Real data for batch output pages count for LOB buffer (up to 10 decimal digits)
Rules for output in the DAT format
  1. For the rules for output in DAT format, see 1.5.3 Rules for output of command execution results in DAT format.
  2. The elements are separated by the comma (,), and information about one global buffer is displayed on each line. If multiple RDAREAs have been allocated to the same global buffer, one line of global buffer definition information is displayed for each allocated RDAREA, and all items other than the RDAREA name are repeated.
  3. Global buffer statistical information including the unit is treated as a character element.
  4. Because the pdbufls command's execution time is included on the title line, this information is displayed only when title line output (-y option) is specified.
  5. If the following information items cannot be acquired, the command displays each item as a null element:
    - Buffer length and number of buffer sectors in the global buffer definition information
    - Previous time the global buffer statistical information was acquired
    The internal information used by the system will be the null value or "".
  6. When information is displayed in DAT format, the following error message is not output:
    [NOT FOUND ss...s=tt...t]