Filter
Top Products
Utilities 7-89
Option Descriptions
The maximum number of locks available is specified as LOCKS in the OnLine
configuration file.
-l Option
Use the -l option to display information about physical and logical logs. You
can interpret output from this option as follows. The first section of the
display describes the physical log configuration:
type indicates the type of lock using the following codes:
HDR
B
S
X
I
U
IX
IS
SIX
header
bytes lock
shared
exclusive
intent
update
intent-exclusive
intent-shared
shared, intent-exclusive
tblsnum is the tblspace number of the locked resource.
rowid is the row identification number. The rowid provides the
following lock information:
■ If the rowid equals 0, the lock is a table lock.
■ If the rowid ends in two 0s, the lock is a page lock.
■ If the rowid is six digits or less and does not end in 0,
the lock is probably a row lock.
■ If the rowid is morethan sixdigits, thelock isprobably
an index key value lock.
size is the number of bytes locked for a VARCHAR lock.
buffer is the address of the physical log buffer.
bufused is the number of pages of the buffer that are used.
bufsize is the size of each physical log buffer in pages.