IBM 000-8697 Manuel D’Utilisation

Utilities

The number of modified buffers, the number of total buffers available, the
number of hash buckets available, and the size of the buffer in bytes are also
listed. The maximum number of buffers available is specified as

BUFFERS

in

the OnLine configuration file.

0x01
0x02
0x04
0x08

Modified data
Data

LRU

Error

pagenum

is the physical page number on the disk.

memaddr

is the buffer memory address.

nslots

is the number of slot-table entries in the page. This indicates
the number of rows (or portions of a row) that are stored on the
page.

pgflags

describes the page type using the following values, alone or in
combination:

1
2
4
8
10
40
80
100
800

data page
tblspace page
free-list page
chunk free-list page
B+-tree root node page
B+-tree branch node page
B+-tree leaf node page
logical log page
physical log

xflgs

describes buffer access using the following flag bits:

0x0100
0x0200
0x0400

share lock
update lock
exclusive lock

owner

is the user process that set the

xflgs

buffer flag.

waitlist

is the address of the first user process waiting for access to this
buffer. For a complete list of all processes waiting for the
buffer, see tbstat -X.