Another link, very useful :
Checkpoint tuning: how to find the bottlenecks in the checkpoint duration time
http://www-1.ibm.com/support/docview...=u tf-8〈=en



----- 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 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 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 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 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 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:09
125b6a848 0 C 2 = 0X2 tempdbs /
dev/chunk01fbs
125b6b068 1 C3 = 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 FuzzyCheckpoint 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 = 0X2tempdbs /
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 CheckpointCompleted: 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 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,

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/