Re: Off and On Informix Performance Issues

Gary Aders wrote: > gaders@masterbrandcabinets.com (Gary Aders) wrote in message > news:<4a5a9f2f.0306100611.83d1fcf@posting.google.com>... >> We have experienced Informix Performance issues where for no reason >> that we can determine, the Informix database slows down. We have run >> a Sniffer product to determine that they are no network issues. In >> fact all other applications are working fine in terms of response >> time. The server Performance monitor shows that the server does not >> seem to have any bottlenecks and the Informix database is the only >> application on this server. The best part is that after a couple of >> days of hair pulling, the performance issue disappears only to >> reappear in the following months. At this point in time, we are >> looking at our connection client which I am told is Inet. Does anyone >> have any knowledge of how to improve Inet? Due to the economy, our >> best Informix person is no longer with the company and I have had no >> formal training so I am sorry if my message is a little incoherent. > > PHYSDBS rootdbs # Location (dbspace) of physical log > PHYSFILE 11000 # Physical log file size (Kbytes) This is quite small and should be in its own dbspace. > # Logical Log Configuration > LOGBUFF 64 # Logical log buffer size (Kbytes)> LOGSMAX 300 # Maximum number of logical log files > LOGFILES 225 # Number of logical log files > LOGSIZE 500 # Logical log size (Kbytes) ARG! Make these about 100 MB each and then have 10. > LTAPEDEV NUL # Log tape device path Not a good idea. You really should hang onto these for recovery. > BUFFERS 1000 # Maximum number of shared buffers There's your problem right there. Should probably be around 100,000 as a starting point. How much RAM, how many CPUS? > # Read Ahead Variables > RA_PAGES 8 # Number of pages to attempt to read> ahead > RA_THRESHOLD 4 # Number of pages left before next> group