IBM 000-8697 Manual Do Utilizador

Utilities

The maximum number of locks available is specified as

LOCKS

in the OnLine

configuration file.

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 more than six digits, the lock is probably
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.