FW: waiting for log buffer??

Posted in 2003

Rajasekaran, Rajesh — Fri, 25 Jul 2003 08:07:42 -0500 — source: Usenet: comp.databases.informix

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C352AD.BBC0CB20 Content-Type: text/plain; charset="iso-8859-1" You can try extending the size of LOGBUFF to say 64 KB ofcourse not exceeding your LOGSIZE. Also, it could be due to PHYSBUFF as well. Do you see physical log forcing checkpoint in your system ? Do y have checkpoints running apart from the CKPTINVL ? In that case,try increasing PHYSBUFF to 1024/2048 again not exceeding PHYSIZE. Please let me know the results in case if you decide to try the above things. Rajesh Rajasekaran Informix Database Administrator Forest Pharmaceuticals Inc. (314) 493-7073 rrajasekaran@forestpharm.com -----Original Message----- From: james [mailto:hohoho@erewhon.com] Sent: Thursday, July 24, 2003 9:30 PM To: informix-list@iiug.org Subject: waiting for log buffer?? I don't understand what is happening (not unusual) in a particular informix instance. ids 7.30.UC7, hpux 10.20 a data loading script is building an index on a temporary table; there are two temp dbspaces, the temp table was created 'with nolog', and the build is using multiple threads. at some point, other sessions, doing inserts and updates to unrelated tables, get a 'G' in the onstat -u first flag position; at this time, the index build session seems to be stuck in a critical section - it shows a 'X' in flag four for a period of time (minutes, not seconds) and the server is *not* in a ckp wait state The sessions stuck on 'G', waiting for a log buffer, do nothing until the index build completes, then continue merrily. The log buffers are 32k default. The instance is logging to /dev/nul. There are 8 log files of 500 MB each. KAIO is being used, 4 cpuvps If anyone could enlighten me as to what is happening, I would appreciate it. A cure would be warmly received as well. tia James ------_=_NextPart_001_01C352AD.BBC0CB20 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2653.12"> <TITLE>FW: waiting for log buffer??</TITLE> </HEAD> <BODY> You can try extending the size of LOGBUFF to say 64 = KB ofcourse not exceeding your LOGSIZE. Also, it could be due to PHYSBUFF as well. Do you see = physical log forcing checkpoint in your system ? Do y have checkpoints = running apart from the CKPTINVL ? In that case,try increasing PHYSBUFF to 1024/2048 = again not exceeding PHYSIZE. Please let me know the results in case if you decide = to try the above things. Rajesh Rajasekaran Informix Database Administrator Forest Pharmaceuticals Inc. (314) 493-7073 rrajasekaran@forestpharm.com -----Original Message----- From: james [<A = HREF=3D"mailto:hohoho@erewhon.com">mailto:hohoho@erewhon.com</A>]= Sent: Thursday, July 24, 2003 9:30 PM To: informix-list@iiug.org Subject: waiting for log buffer?? I don't understand what is happening (not unusual) in = a particular informix instance. ids 7.30.UC7, hpux 10.20 a data loading script is building an index on a = temporary table; there are two temp dbspaces, the temp table was created = 'with nolog', and the build is using multiple threads. at some point, other sessions, doing inserts and = updates to unrelated tables, get a 'G' in the onstat -u first flag = position; at this time, the index build session seems to be stuck in a = critical section - it shows a 'X' in flag four for a period of time = (minutes, not seconds) and the server is *not* in a ckp wait state The sessions stuck on 'G', waiting for a log buffer, = do nothing until the index build completes, then continue = merrily. The log buffers are 32k default. The instance is = logging to /dev/nul. There are 8 log files of 500 MB each. KAIO is being used, 4 cpuvps If anyone could enlighten me as to what is happening, = I would appreciate it. A cure would be warmly received as = well. tia James </BODY> </HTML> ------_=_NextPart_001_01C352AD.BBC0CB20-- sending to informix-list

FW: waiting for log buffer??

Related threads

Your privacy choices