7-88 IBM Informix OnLine Database Server Administrator’s Guide
Option Descriptions
-k Option
Usethe -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
returnfrom its write in a specific amount of time. This is also
known as atime-out condition. The tbinit daemon does not
knowwhat 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 isC,data is the chunk number to which the
pagecleaner is writing buffers. If state is L,data is the LRU
queuefrom 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 isthe 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 isthe shared-memory address of the process holding the lock.
Thisaddress corresponds to the address in the address fieldof
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.