Not sure if I have a problem with CKPs

IDS 12.10.FC12 Solaris 10 1/13 I sometimes observe a period of very frequent checkpoints. The system is a primary and there is one RSS. Here is an example of what I observe: informix@ifmx-prod-anc>onstat -g ckp IBM Informix Dynamic Server Version 12.10.FC12 -- On-Line -- Up 1 days 23:47:31 -- 19693568 Kbytes AUTO_CKPTS=On RTO_SERVER_RESTART=Off Critical Sections Physical Log Logical Log Clock Total Flush Block # Ckpt Wait Long # Dirty Dskflu Total Avg Total Avg Interval Time Trigger LSN Time Time Time Waits Time Time Time Buffers /Sec Pages /Sec Pages /Sec 727476 10:00:09 IPL 39083:0x7658018 0.0 0.0 0.0 2 0.0 0.0 0.0 112 112 119 119 33 33 727477 10:00:10 IPL 39083:0x7a50018 0.0 0.0 0.0 1 0.0 0.0 0.0 449 449 500 500 1016 1016 727478 10:00:10 IPL 39083:0x7a66018 0.0 0.0 0.0 2 0.0 0.0 0.0 47 47 115 115 22 22 727479 10:00:11 IPL 39083:0x7d74018 0.0 0.0 0.0 1 0.0 0.0 0.0 523 523 133 133 782 782 727480 10:00:15 IPL 39083:0x801c018 0.1 0.1 0.0 2 0.0 0.0 0.0 1467 1467 1194 298 680 170 727481 10:00:39 IPL 39083:0xc0a8018 0.2 0.2 0.0 1 0.0 0.0 0.0 5324 5324 5307 221 16524 688 727482 10:00:39 IPL 39083:0xc0bb018 0.0 0.0 0.0 1 0.0 0.0 0.0 67 67 325 325 19 19 727483 10:00:39 IPL 39083:0xc0fd018 0.0 0.0 0.0 1 0.0 0.0 0.0 74 74 76 76 66 66 727484 10:00:40 IPL 39083:0xc135018 0.0 0.0 0.0 1 0.0 0.0 0.0 135 135 133 133 56 56 727485 10:00:42 IPL 39083:0xc628018 0.0 0.0 0.0 2 0.0 0.0 0.0 608 608 624 312 1275 637 727486 10:00:42 IPL 39083:0xc639018 0.0 0.0 0.0 1 0.0 0.0 0.0 56 56 147 147 20 20 727487 10:00:42 IPL 39083:0xc64e018 0.0 0.0 0.0 1 0.0 0.0 0.0 56 56 113 113 24 24 727488 10:00:42 IPL 39083:0xc6902c0 0.0 0.0 0.0 3 0.0 0.0 0.0 114 114 168 168 69 69 727489 10:00:43 IPL 39084:0x294018 0.0 0.0 0.0 1 0.0 0.0 0.0 535 535 583 583 1028 1028 727490 10:00:43 IPL 39084:0x2cd018 0.0 0.0 0.0 2 0.0 0.0 0.0 130 130 246 246 57 57 727491 10:00:43 IPL 39084:0x330018 0.0 0.0 0.0 1 0.0 0.0 0.0 80 80 72 72 99 99 727492 10:10:55 CKPTINTVL 39084:0x2841018 0.2 0.2 0.0 1 0.0 0.0 0.0 8836 8836 5148 8 9496 15 727493 10:20:55 CKPTINTVL 39084:0x4c54018 0.3 0.3 0.0 0 0.0 0.0 0.0 10229 10229 10178 16 9235 15 727494 10:30:55 CKPTINTVL 39084:0x666e018 0.1 0.1 0.0 0 0.0 0.0 0.0 1844 1844 1839 3 6682 11 727495 10:40:55 CKPTINTVL 39084:0x9b41018 0.4 0.4 0.0 0 0.0 0.0 0.0 15507 15507 12338 20 13523 22 Max Plog Max Llog Max Dskflush Avg Dskflush Avg Dirty Blocked pages/sec pages/sec Time pages/sec pages/sec Time 10240 2084 1 5410 6 0 I don't see any messages in the log, though. I wonder if these could be secondary checkpoints (from index builds) that Madison mentioned a couple years ago when replying to someone's question about frequent checkpoints. If so, maybe there is no problem brewing at all (?) Thank you for any comments. Regards, DG

Sorry. My reference to Madison's comment is this thread: http://members.iiug.org/forums/ids/index.cgi/read/31286 DG

Hi. You should not worry about checkpoints, unless they are causing slowness on your cluster. IPL triggers are supposed to be caused by index page, as discussed on this technote. http://www-01.ibm.com/support/docview.wss?uid=swg21978550 HTH Alexandre Marini