
7-88 IBM Informix OnLine Database Server Administrator’s Guide
Option Descriptions
-k Option
Usethe-koptiontodisplayinformation about activelocks.You caninterpret
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 indicateseither that OnLine is in the process
of performing a shutdown or that a page cleaner did not
returnfromits write ina specificamount of time.This isalso
known as a time-out condition. The tbinit daemon does not
knowwhathappenedtothecleaner,soitismarkedas“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
queuefromwhichthepagecleaneriswriting.Thedata value
is displayed as a decimal, followed by an equal sign, and
repeated as a hexadecimal.
address istheaddressofthelockinthelocktable.Thisaddressappears
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 theshared-memory address of the processholding thelock.
Thisaddresscorrespondstotheaddressintheaddress fieldof
tbstat -u (users) output.Ifthe value ofowner is 0, thedatabase
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.
Comentarios a estos manuales