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 whichthe 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 inthe 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.
