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.

HiRDB administrator

(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.

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

   

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.

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 the event log 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 the event log, 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

   

Explanation

• Reset occurs at point A
  All the information items for display at point A are 0 except for the following:
  Number of current reference buffers
  Number of current update buffers
  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:
  Number of current reference buffers
  Number of current update buffers
  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:
  Buffer sector count
  Number of current reference buffers
  Number of current update buffers
  Number of update buffers for the next time output of a deferred write trigger occurs
  Number of lock release waits during lock processing on the buffer management area
  Percentage of buffer contention-lock release waits resulting from buffer lock processing
  Average sleep processing execution count of buffer lock processing
  Percentage of buffer lock processing in spin processing
  Average spin loop execution count during buffer lock processing
  Buffer pool lock exclusive time during synchronization point processing
  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.
  

(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 43 characters).

If multiple names are defined, multiple names are output. However, there is no output in the case of the Other 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.

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

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)

• -k def
  

  "DEFINE_OF_GLOBAL_BUFFER"[CR] "EDIT_TIME"[CR] "aa...a"[CR] "BUFFNAME","SVID","TYPE","SIZE","NUM","WRATIO","RDAREA/INDEX_NAME","PRMAX", "PRNUM","CSIZE","MAPS"[CR] "bb...b","cc...c","d",ee,ff...f,ggg,"hh...h",kk...k,lll,mm...m,nn[CR]

• -k sts
  

  "STATISTICS_OF_GLOBAL_BUFFER"[CR] "EDIT_TIME"[CR] "aa...a"[CR] "BUFFNAME","SVID","LAST_EXEC_TIME","HIT","REFHIT","UPDHIT","RFGET","UPGET", "READ","WRITE","RFFLS","UPFLS","REFBUF","UPBUF","TRG","WAITL","SYNC", "PRRED","PRHIT","PRINS","PRREQ","INSB","LRREQ","LWREQ","LRPAG","LWPAG", "CINSM","CFMAX","CFAVG","RFGETR","UPGETR","RFHITR","UPHITR","READR","WRITER", "RFFLSR","UPFLSR","WAITLR","SYNCR","PRREDR","PRHITR","PRINSR","PRREQR","INSBR", "LRREQR","LWREQR","LRPAGR","LWPAGR"[CR] "bb...b","cc...c","dd...d",eee,fff,ggg,"hh...h","ii...i", "jj...j","kk...k","ll...l","mm...m",nn...n,oo...o,pp...p,"qq...q","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","GG...G","HH...H","II...I","JJ...J","KK...K","LL...L", "MM...M","NN...N","OO...O","PP...P","QQ...Q","RR...R","SS...S","TT...T","UU...U", "VV...V","WW...W","XX...X","YY...Y"[CR]

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]