I'm not really an Informix Admin but we do have a critical application running on IDS 9.4.
IBM Informix Dynamic Server Version 9.40.FC3 -- On-Line -- Up 00:08:18 -- 42016 Kbytes
Everytime we reach a month end where transaction volume are high we experienced this kind of instanace state. Upon checking the log I can't find any critical issue with the server. I can only see the this on the *.msg file.
<<IBM Informix Dynamic Server>>> WARNING! Physical Log size 11200 is too small.
Physical Log overflows may occur during peak activity.
Recommended minimum Physical Log size is 20 times maximum
concurrent user threads.
<<IBM Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into
a locked state. Recommended minimum buffer pool size is
4 times maximum concurrent user threads.
I've already changed the physical log size however I can't find any reference on the net on how to change the buffer pool size to a higher value. Please help. Thanks.