Filter
Top Products
Utilities 7-83
Option Descriptions
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.