IBM Informix Dynamic Server Version 12.10.FC14 -- On-Line (Prim) -- Up 109 days 18:32:31 -- 46353692 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 36279 08:31:30 CKPTINTVL 3783:0x71f1018 0.3 0.2 0.0 0 0.0 0.0 0.0 678 678 489 1 339 1 36280 08:36:30 CKPTINTVL 3783:0x721f018 0.1 0.1 0.0 0 0.0 0.0 0.0 398 398 141 0 46 0 36281 08:41:30 CKPTINTVL 3783:0x73be018 0.4 0.3 0.0 0 0.0 0.0 0.0 5664 5664 519 1 418 1 36282 08:46:30 CKPTINTVL 3783:0x770e018 1.0 0.9 0.0 1 0.0 0.0 0.0 14301 14301 1351 4 849 2 36283 08:51:33 CKPTINTVL 3783:0x8195018 3.0 2.8 0.0 0 0.0 0.0 0.0 22086 7828 3145 10 2697 8 36284 08:56:34 CKPTINTVL 3783:0x862f018 1.9 1.8 0.0 0 0.0 0.0 0.0 8541 4698 1598 5 1179 3 36285 09:02:15 CKPTINTVL 3783:0x8a27018 39.8 35.4 0.0 10 0.9 2.4 3.3 4833 136 1516 4 1122 3 36286 09:06:49 CKPTINTVL 3783:0x905b018 2.4 2.2 0.0 0 0.0 0.0 0.0 10837 4821 2512 8 1588 5 36287 09:11:55 CKPTINTVL 3783:0x9b99544 6.7 5.6 0.0 0 0.0 0.0 0.0 10658 1890 2737 9 2889 9 36288 09:16:56 CKPTINTVL 3783:0xa812350 2.0 1.9 0.0 0 0.0 0.0 0.0 8951 4777 3625 11 3213 10 36289 09:25:35 CKPTINTVL 3783:0xacec018 219.4 208.5 0.0 17 2.8 4.0 6.4 7934 38 1767 5 1784 5 36290 09:27:46 CKPTINTVL 3783:0xb057018 41.6 36.9 0.0 10 1.1 1.8 3.3 6886 186 2059 6 1033 3 36291 09:32:20 CKPTINTVL 3783:0xb93b280 4.2 4.1 0.0 1 0.0 0.0 0.0 14972 3634 2716 8 2306 7 36292 09:37:21 CKPTINTVL 3783:0xc10e018 1.3 1.2 0.0 1 0.0 0.0 0.0 10331 8441 2209 7 2017 6 36293 09:42:33 CKPTINTVL 3783:0xc4d97cc 12.9 12.1 0.0 2 0.2 0.4 0.6 13537 1121 1714 5 1051 3 36294 09:47:52 CKPTINTVL 3783:0xc9346d0 18.3 17.0 0.0 1 0.1 0.6 0.6 14930 880 1901 6 1163 3 36295 09:52:52 CKPTINTVL 3783:0xcd9a67c 0.9 0.9 0.0 1 0.0 0.0 0.0 13310 13310 1702 5 1126 3 36296 09:58:11 CKPTINTVL 3783:0xd2d22b4 19.5 18.9 0.0 3 0.0 0.2 0.5 12403 656 2203 7 1436 4 36297 10:03:18 CKPTINTVL 3783:0xd86f018 7.1 7.1 0.0 0 0.0 0.0 0.0 8442 1190 2606 8 1437 4 36298 10:08:18 CKPTINTVL 3783:0xd9ef018 0.5 0.5 0.0 0 0.0 0.0 0.0 4022 4022 1152 3 384 1 Max Plog Max Llog Max Dskflush Avg Dskflush Avg Dirty Blocked pages/sec pages/sec Time pages/sec pages/sec Time 10240 4103 1668 1 0 0 Based on the current workload, the physical log might be too small to accommodate the time it takes to flush the buffer pool during checkpoint processing. The server might block transactions during checkpoints. If the server blocks transactions, increase the physical log size to at least 34877440 KB.