i have used a script from www.oninit.com that analyze
many parameters of IDS, i need yout help for optimization
of some paramters (Read cache, PHYSBUFF, LOGBUFF, buffers allocated to index data..)
Here is the output of the script :
Read cache is below minimum target of 90% at 0.00%.
Write cache is satisfactory [91.51%].
2 deadlock(s) detected.
0 lock timeout(s) detected.
LRU Contention is excellent [.46%].
0 of the last 60 checkpoint(s) were longer than 2 seconds. PHYSBUFF can be decreased [0.00%].
LOGBUFF can be decreased [16.56%]. Logical logs are OK [94% free].
No foreground writes detected.
Shared memory segment count OK. 4 AIO/KAIO VPs have less than 1 I/O per wakeup. Read Ahead buffer usage is excellent [99.72%].
Buffer wait ratio is good [12.70%].
Lock wait ratio is excellent [0.00%]. Buffers allocated to index data is dangerously high [89.44%]. Buffers allocated to "other uses" is acceptable [0.18%].
That script seems to be very nice.
I'd like test it.
I know oninit.com but i didn't know the script.
Which is the URL ? (Thanks)
Maybe you have to look at "http://www.oninit.com/database/" at the onstat references, they explain at each onstat command how to tune.
Per exemple onstat -p handles about read cache and write chache, ...
And good stuff at :http://www.informix.kiev.ua/articles...or/monitor.htm