IBM 000-8697 Manual Do Utilizador

Página de 702
7-88
IBM Informix OnLine Database Server Administrator’s Guide
Option Descriptions
-k Option
Use the -k option to display information about active locks. You can interpret
output from this option as follows:
state
indicates the current page-cleaner activity using the
following codes:
C
E
I
L
chunk write
exit
cleaner is idle
LRU
 queue
The “exit” code indicates either that OnLine is in the process
of performing a shutdown or that a page cleaner did not
return from its write in a specific amount of time. This is also
known as a time-out condition. The tbinit daemon does not
know what happened to the cleaner, so it is marked as “exit.”
In either case, the cleaner process eventually exits.
data
provides additional information in concert with the
state
field. If
state
 is
C
,
data
 is the chunk number to which the
page cleaner is writing buffers. If
state
is
L
,
data
is the
LRU
queue from which the page cleaner is writing. The
data
value
is displayed as a decimal, followed by an equal sign, and
repeated as a hexadecimal.
address
is the address of the lock in the lock table. This address appears
in the
wait
 field of the tbstat -u (users) output for the user
process that is waiting for this lock.
wtlist
is the first entry in the list of user processes waiting for the
lock, if there is one.
owner
is the shared-memory address of the process holding the lock.
This address corresponds to the address in the
address
field of
tbstat -u
(users) output. If the value of
owner
is 0, the database
server process that owned the transaction is dead.
lklist
is the next lock in a linked list of locks held by the owner just
listed.