H E LP !

18:16:55 Maximum server connections 65 18:22:03 Fuzzy Checkpoint Completed: duration was 8 seconds, 1343 buffers not flushed, timestamp: -187712012. 18:22:03 Checkpoint loguniq 7553, logpos 0x34b9018, timestamp: -187712012 18:22:03 Maximum server connections 65 18:27:14 Fuzzy Checkpoint Completed: duration was 11 seconds, 165 buffers not flushed, timestamp: -187623455. 18:27:14 Checkpoint loguniq 7553, logpos 0x4813030, timestamp: -187623455 ________________________________________________________________________ Dear All, I am a new user of informix 9.40.UC2 on Solaris SunOS 5.8. running an ATM switch. Since last week I have noticed that duration was between 2 to 5 seconds and now it is 8 to 12 seconds, can someone please tell me what it is and what is the impect on the performance of informix, and is there anything we can do to lower the duration. The server it is only 45% busy, but the transactions taking more time to complete. Thanks & regards

SYED ALI said: > 18:16:55 Maximum server connections 65 > 18:22:03 Fuzzy Checkpoint Completed: duration was 8 seconds, 1343 buffers > not > flushed, > timestamp: -187712012. > 18:22:03 Checkpoint loguniq 7553, logpos 0x34b9018, timestamp: -187712012 > > 18:22:03 Maximum server connections 65 > 18:27:14 Fuzzy Checkpoint Completed: duration was 11 seconds, 165 buffers > not > flushed, > timestamp: -187623455. > 18:27:14 Checkpoint loguniq 7553, logpos 0x4813030, timestamp: -187623455 > ________________________________________________________________________ > > Dear All, > > I am a new user of informix 9.40.UC2 on Solaris SunOS 5.8. running an ATM > switch. > > Since last week I have noticed that duration was between 2 to 5 seconds > and > now it is 8 to 12 seconds, can someone please tell me what it is and what > is > the impect on the performance of informix, and is there anything we can do > to > lower the duration. The server it is only 45% busy, but the transactions > taking more time to complete. It can impact performance and the way to address it is GENERALLY to increase the number of LRUS and CLEANERS and reduce CHKPTINVL. It might also be worth increasing NUMAIOVPS. However, output from onstat -D might show that one dbspace is being clobbered, in which case having more CLEANERS and more AIO VPS might actually make things worse. If this is the case, then you might want to DECREASE CLEANERS and NUMAIOVPS slightly and definitely redistribute your hot tables across multiple dbspaces. If you have one hot table, then use ALTER FRAGMENT to partition the table across multiple dbspaces. -- Bye now, Obnoxio "There were a myriad of problems which conspired to corrupt your reason and rob you of your common sense. Fear got the best of you, and in your panic you turned to the Labour Party. They promised you order, they promised you peace, and all they demanded in return was your silent, obedient consent." -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.

Execute Update Statistics for table name_table for DataBase ???? bye <span style="color:rgb(0, 51, 102);font-weight:bold">The freedom of Linux ... The power of Informix</span> >From: "SYED ALI" <smohsin1@gmail.com> >Reply-To: ids@iiug.org >To: ids@iiug.org >Subject: H E LP ! [10867] >Date: Mon, 7 Jan 2008 03:37:11 -0500 (EST) > >18:16:55 Maximum server connections 65 >18:22:03 Fuzzy Checkpoint Completed: duration was 8 seconds, 1343 buffers >not >flushed, >timestamp: -187712012. >18:22:03 Checkpoint loguniq 7553, logpos 0x34b9018, timestamp: -187712012 > >18:22:03 Maximum server connections 65 >18:27:14 Fuzzy Checkpoint Completed: duration was 11 seconds, 165 buffers >not >flushed, >timestamp: -187623455. >18:27:14 Checkpoint loguniq 7553, logpos 0x4813030, timestamp: -187623455 >________________________________________________________________________ > >Dear All, > >I am a new user of informix 9.40.UC2 on Solaris SunOS 5.8. running an ATM >switch. > >Since last week I have noticed that duration was between 2 to 5 seconds and >now it is 8 to 12 seconds, can someone please tell me what it is and what >is >the impect on the performance of informix, and is there anything we can do >to >lower the duration. The server it is only 45% busy, but the transactions >taking more time to complete. > >Thanks & regards > > >******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >See you at the IIUG Informix 2008 Conference >The Power Conference for Informix Professionals >April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas >http://www.iiug.org/conf >Registration Now Open!! _________________________________________________________________ Sabe más sobre la próxima generación del MSN Messenger. http://imagine-msn.com/minisites/messenger/default.aspx?locale=es-ar