Informix Server Performances

[aroui]

Hi all ,
i have used a script from

http://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%].

Thank u in advance,

 

[lgodoy]

Hi there,

How did you get this script healthcheck from

http://www.oninit.com,

I could not found any place on

http://www.oninit.com

to download this.

Also there is this variable set in the script, I saw the content using the View button, whcih requires some more download from that website too.
#SCCSDIR=${SCCSDIR:="/home/tools/SCCS/"}
#. ${SCCSDIR}.std.env

Any advice would be appreciated!

Thanks.

 

[aroui]

hello,

go to :

http://www.oninit.com/scripts/healthcheck

regards,