ovbuf hitting 427 over night

Hello I am new to this site and filling in for our Informix DBA. We are having an issue with Informix version 7.31. During the day when we run onstat -p all the statistics look fine. At sometime during the night theovbuf paramater spikes up to 427. I know this can cause a performance issue. I was just wondering if anyone has had an issue like this and if so what solutions did they use to fix the problem. Any help would be greatly appreciated. As you can see I am a SQL Server DBA so Informix is not something I am familiar with. Thanks for any help you can give me. > Phil Holtquist > SQL Server DBA > Follett Higher Education Group > 708-437-2083 > > pholtquist@fheg.follett.com > > >

The database system log is located as defined by the MSGPATH setting in the configuration file. Check the log and see if there is any additional information listed. What processes run overnight? -----Original Message----- From: Holtquist, .... [mailto:pholtquist@fheg.follett.com] Sent: Wednesday, August 13, 2003 3:33 PM To: ids@iiug.org Subject: ovbuf hitting 427 over night [1684] Hello I am new to this site and filling in for our Informix DBA. We are having an issue with Informix version 7.31. During the day when we run onstat -p all the statistics look fine. At sometime during the night theovbuf paramater spikes up to 427. I know this can cause a performance issue. I was just wondering if anyone has had an issue like this and if so what solutions did they use to fix the problem. Any help would be greatly appreciated. As you can see I am a SQL Server DBA so Informix is not something I am familiar with. Thanks for any help you can give me. > Phil Holtquist > SQL Server DBA > Follett Higher Education Group > 708-437-2083 > > pholtquist@fheg.follett.com > > > "CONFIDENTIALITY NOTICE: This message originates from WHSmith USA Travel Retail. This email message and all attachments may contain legally privileged and confidential information intended solely for the use of the addressee. If you are not the intended recipient, you should immediately stop reading this message and delete it from the system. Any unauthorized reading, distribution, copying, or other use of this message or its attachments is strictly prohibited. All personal messages express solely the sender's views and not those of WHSmith USA Travel Retail. This message may not be copied or distributed without this disclaimer."

Holtquist, .... wrote: > Hello > > I am new to this site and filling in for our Informix DBA. We are > having an issue with Informix version 7.31. During the day when we run > onstat -p all the statistics look fine. At sometime during the night the> ovbuf paramater spikes up to 427. I know this can cause a performance > issue. I was just wondering if anyone has had an issue like this and if so > what solutions did they use to fix the problem. Add more buffers? Basically it means you ran out of buffers on several occasions. It sounds like a batch job is saturating the buffers over night. This may not be seen as a performance issue if the job is running in an acceptable time. If you have spare memory, then you can consider allocating more buffers to help the job. In terms of the value of ovbuf, it's not a case of it's value, but how quickly it gets there. Small increments can be seen as not a problem, whereas a large leap could be causing problems for all sessions running at that time. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+