infos about waitstates

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, > > 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, the only information i know of this topic: http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic=/com.ibm.adref.doc/ids_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.