We've got some performance problems with a baan/informix installation.
After informix restart, the application is quite fast for few days.
But after some days buffer wait (and io wait at os-level) starts to increase.
I found a health_check script (oninit.com).
It gave me warning:
Buffers allocated to index data is dangerously high [97.68%].
The script took that from onstat -P :
# onstat -
Informix Dynamic Server Version 7.31.FC6 -- On-Line -- Up 12 days 03:26:28 -- 4641784 Kbytes
#onstat -P | tail -4
Is this bad?
Sounds quite odd to me that indexes are using all the buffers.