pdbufls (Display global buffer information)

Function

The pdbufls command displays the status of global buffers.

Executor

HiRDB administrator

Format

pdbufls [-k output-type][-d] [-x [-y]]
       [{-s server-name[,server-name]...
       | -a global-buffer-name[,global-buffer-name]...}]

Options

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.

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.

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.

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.

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

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

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. Figure 2-1 shows the collection range of 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.

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.

Output format

-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: Other1
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 43 characters).
If multiple names are defined, multiple names are output. However, there is no output in the case of the Other1 global buffer type. There is also no output in the case of RDAREA or index deletion. 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.

1 Global buffer specified in the -o option of the pdbuffer operand in the system common definition.

-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.1
ii...i
Number of update GETs.1
jj...j
Number of actual READs.1
kk...k
Number of actual WRITEs.1
ll...l
Number of reference buffer flushes.1
mm...m
Number of update buffer flushes.1
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.1
rr...r
Number of DB synchronization points.1
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.1
vvv
Prefetch hit range (3 decimal digits).
ww...w
Number of prefetch buffer shortages.1
xx...x
Number of prefetch READ requests.1
yy...y
Number of out of buffer errors.1
zz...z
Number of LOB buffer read requests.1
AA...A
Number of LOB buffer write requests.1
BB...B
Number of pages input into LOB buffer in batch.1
CC...C
Number of pages output from LOB buffer in batch.1
DD...D
Internal information used by the system.
EE...E
Internal information used by the system.
FF...F
Internal information used by the system.

1 The display format is as follows:

Numeric rangeDisplay format
0[Figure] 9990[Figure] 999
1,000[Figure] 9,9941.00K[Figure] 9.99K1
9,995[Figure] 99,94910.0K[Figure] 99.9K1
99,950[Figure] 999,499100K[Figure] 999K1
999,500[Figure] 9,994,9991.00M[Figure] 9.99M1
9,995,000[Figure] 99,949,99910.0M[Figure] 99.9M1
99,950,000[Figure] 999,499,999100M[Figure] 999M1
999,500,000[Figure] 4,294,967,2951.00G[Figure] 4.29G1

K: Kilo

M: Mega

G: Giga

1 The decimal place beyond the displayed digits is rounded off.

Note
[CR] indicates a linefeed.
Rules for output in the DAT format
  1. 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.
  2. When a character element is included, it is enclosed in double quotation marks ("). Global buffer statistical information including the unit is treated as a character element.
  3. 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.
  4. If the following information items cannot be acquired, the command displays the null value for a numeric element and only "" for a character 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 "".
  5. When information is displayed in DAT format, the following error message is not output:
    [NOT FOUND ss...s=tt...t]