forsms
9th May 2002, 02:57
onstat ...V class
In informix, the onstat -g seg is showing me around 25 entries for "V" class...

how to reduce this to 1 or 2..?

One way which I did, is restarting informix...but is that the only solution?

Thanks,

makiju
10th May 2002, 13:46
You need to tune your onconfig:

SHMVIRTSIZE 4194304 #initial virtual shared memory segment size
SHMADD 524288 # Size of new shared memory segments (Kbytes)

Increase value SHMVIRTSIZE to bigger value. Avoid external memory segments because they will slow down your Informix performance dramatically.