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/infoce...c/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/docvie... s=utf-8〈=en


Looking the result bellow... we see the checkpoint take more timewriting 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, 366
buffers not flushed,

20/07/2007 17:07
125ba15c8 108 L 183 = 0Xb7 LRU-183
16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366
buffers 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, 366
buffers not flushed,

20/07/2007 17:07
125b6a848 0 C 2 = 0X2 tempdbs /
dev/chunk01fbs
125b6b068 1 C3 = 0X3 dbsfbs01 /
dev/chunk02fbs
16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366
buffers 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 FuzzyCheckpoint Completed: duration was 21 seconds, 366
buffers 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, 366
buffers not flushed,

20/07/2007 17:07
125b6a848 0 C 2 = 0X2tempdbs /
dev/chunk01fbs
125b6b068 1 C 3= 0X3 dbsfbs01 /
dev/chunk02fbs
16:57:32 Fuzzy Checkpoint Completed: duration was 21 seconds, 366
buffers 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 CheckpointCompleted: duration was 21 seconds, 366
buffers 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, 366
buffers 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, 366
buffers not flushed,

20/07/2007 17:07
125b6b068 1 C 3 = 0X3 dbsfbs01 /
dev/chunk02fbs
16:57:32Fuzzy Checkpoint Completed: duration was 21 seconds, 366
buffers 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, 366
buffers 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, 366
buffers 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, 366
buffers 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, 366
buffers 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, 366
buffers not flushed,

20/07/2007 17:07
125b6b068 1 C 3 = 0X3 dbsfbs01 /
dev/chunk02fbs
16:57:32 Fuzzy Checkpoint Completed: durationwas 21 seconds, 366
buffers 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 was16 seconds, 396
buffers not flushed,

20/07/2007 17:09
125b6a8480 C 2 = 0X2 tempdbs /
dev/chunk01fbs
125b6b068 1 C 3 = 0X3 dbsfbs01 /
dev/chunk02fbs
17:07:52 Fuzzy Checkpoint Completed: duration was 16 seconds, 396
buffers 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, 396
buffers 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,396
buffers 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, 396
buffers 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, 396
buffers not flushed,

20/07/2007 17:09
125b6b068 1 C 3 = 0X3 dbsfbs01 /
dev/chunk02fbs
17:07:52 FuzzyCheckpoint Completed: duration was 16 seconds, 396
buffers 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, 396
buffers 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, 396
buffers 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, 396
buffers 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, 396
buffers 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, 396
buffers 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, 396
buffers 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, 396
buffers 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, 396
buffers not flushed,

_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list







Flickr agora em português. Você cria, todo mundo vê.
http://www.flickr.com.br/