Res: Res: long checkpoints on informix

Hi Nicolas, That scrips only show part of the comand "onstat -F" , second by second. This link have more information about the command: http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.adref.doc/adref409.htm With this command you can trace what chunk you have more write and trace if the problem is your storage... table layout... LRU...Cleaners...etc.. you can try this script too: http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&context=SSHPYE&q1=checkpoint&q2=mystat&uid=swg21138794&loc=en_US&cs=utf-8〈=en Looking the result bellow... we see the checkpoint take more time writing the chunk dbsfbs01 ... check with oncheck -pe what tables are in this chunk... the amount of data deleted/inserted/updated by application ...and trace another configurations like, storage, lru, lru max/min, cleaners, buffers... ----- Mensagem original ---- De: Nicolas Garimaldi <Sakura.ggxx@gmail.com> Para: informix-list@iiug.org Enviadas: Sexta-feira, 20 de Julho de 2007 17:24:15 Assunto: Re: Res: long checkpoints on informix well i use your script and this is the result, is little hard to understand 20/07/2007 17:07 125ba15c8 108 L 183 = 0Xb7 LRU-183 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125ba15c8 108 L 183 = 0Xb7 LRU-183 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125b6a848 0 C 2 = 0X2 tempdbs / dev/chunk01fbs 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125b6a848 0 C 2 = 0X2 tempdbs / dev/chunk01fbs 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125b6a848 0 C 2 = 0X2 tempdbs / dev/chunk01fbs 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125b6a848 0 C 2 = 0X2 tempdbs / dev/chunk01fbs 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125b6a848 0 C 2 = 0X2 tempdbs / dev/chunk01fbs 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125b6a848 0 C 2 = 0X2 tempdbs / dev/chunk01fbs 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:07 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366buffers not flushed, 20/07/2007 17:09 125b6a848 0 C 2 = 0X2 tempdbs / dev/chunk01fbs 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 17:07:52 Fuzzy Checkpoint Completed: duration was 16 seconds, 396buffers not flushed, 20/07/2007 17:09 125b6a848 0 C 2 = 0X2 tempdbs / dev/chunk01fbs 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 17:07:52 Fuzzy Checkpoint Completed: duration was 16 seconds, 396buffers not flushed, 20/07/2007 17:09 125b6a848 0 C 2 = 0X2 tempdbs / dev/chunk01fbs 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 17:07:52 Fuzzy Checkpoint Completed: duration was 16 seconds, 396buffers not flushed, 20/07/2007 17:09 125b6a848 0 C 2 = 0X2 tempdbs / dev/chunk01fbs 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 17:07:52 Fuzzy Checkpoint Completed: duration was 16 seconds, 396buffers not flushed, 20/07/2007 17:09 125b6a848 0 C 2 = 0X2 tempdbs / dev/chunk01fbs 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 17:07:52 Fuzzy Checkpoint Completed: duration was 16 seconds, 396buffers not flushed, 20/07/2007 17:09 125b6a848 0 C 2 = 0X2 tempdbs / dev/chunk01fbs 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 17:07:52 Fuzzy Checkpoint Completed: duration was 16 seconds, 396buffers not flushed, 20/07/2007 17:09 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 17:07:52 Fuzzy Checkpoint Completed: duration was 16 seconds, 396buffers not flushed, 20/07/2007 17:09 125b6b068 1 C 3 = 0X3 dbsfbs01 / dev/chunk02fbs 17:07:52 Fuzzy Checkpoint Completed: duration was 16 seconds, 396buffers not flushed, 20/07/2007 1