Hi,



I'm searching for detailled informations about waitstates and how to
interpret them and how to react.



Examples:



buf ready

aio

mt yield n

running

buffer

mt ready

log i/o

mt yield 0

mutex

mt yield

sort io

checkpoint



The manual I checked and IBM Informix Dynamic Server Version 11.50 -
Information Center don't contain much of those stuff.



TIA

Reinhard.

Hi, I'm sending you two docs about Informix performance & tuning.
I hope you will find there some useful topics related to the above
question.

Have a nice day
Francesco

On 18 Jul., 09:07, "Habichtsberg, Reinhard" <RHabichtsb...@arz-
emmendingen.de> wrote:
Hi,
the only information i know of this topic:
http://publib.boulder.ibm.com/infoce...s_adr_0592.htm

* chkpt cond: The thread waited for a checkpoint condition.
* cp mutex: The thread waited for checkpoint mutex to become
available.
* deadlock mutex: The thread waited for a deadlock mutex to become
available.
* empty Q: The thread waited for an empty buffer on a queue.
* fork: The thread waited for a child thread to run.
* full Q: The thread waited for a full buffer on a queue.
* IO Idle: The I/O thread was idle.
* IO Wait: The thread yielded while waiting for I/O completion.
* join wait: The thread waited for another thread to exit.
* lock mutex: The thread waited for lock mutex to become
available.
* lockfree mutex: The thread waited for a lock-free mutex to
become available.
* logflush: Logical log flushing occurred.
* log mutex: The thread waited for logical log mutex to become
available.
* logcopy cond: The thread waited for logical log copy condition.
* logio cond: The thread waited for a logical log condition.
* lrus mutex: The thread waited for a buffer LRU mutex to become
available.
* misc: The thread waited for a miscellaneous reason.
* other cond: The thread waited for an internal condition.
* other mutex: The thread waited for an internal system mutex to
become available.
* other yield: The thread yielded for an internal reason.
* OS read: The thread waited for an operating system read call to
complete.
* OS write: The thread waited for an operating system write call
to complete.
* ready: The thread was ready to run.
* run: The thread ran.
* sort io: The thread waited for sort I/O completion.
* yield bufwait: The thread yielded while waiting for a buffer to
become available.
* yield 0: The thread yielded with an immediate timeout.
* yield time: The thread yielded with a timeout.
* yield forever: The thread yielded and will stay that way until
it wakes up.