We see the following waitstates on one of our Informix 11.50FC7W3
servers. He is running OLTP but also Decision Support.
(sum) 81125424549,00
reason aio
(sum) 62105207794,00
reason buffer
(sum) 61713678094,10
reason mt yield n
(sum) 61561288458,60
reason mt yield
(sum) 29339327941,19
reason mt ready
(sum) 15649570039,20
reason running
(sum) 3340893922,100
reason log i/o
(sum) 1550362515,000
reason mt yield 0
(sum) 1439244418,300
reason checkpoint
(sum) 162272243,0000
reason lock
(sum) 157356745,3000
reason mutex
(sum) 21639138,60000
reason full Q
What do you suggest to reduce IO and Bufferwaits. My idea is to increase
the buffers.
TIA,
Reinhard.