Hi all ,

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%].

Thanks in advance,

Hi,
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


Bye,

Hi,

Go to http://www.oninit.com/scripts/index.html
(Health check script)
Have fun