[informix@pksprodsgadb01 lockwt]$ onstat -g ckp IBM Informix Dynamic Server Version 12.10.FC6WE -- On-Line (Prim) -- Up 94 days 22:44:15 -- 16505084 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 66857 08:11:05 CKPTINTVL 4800:0x1e18a018 5.6 5.4 0.0 0 0.0 0.0 0.0 1981 368 1656 5 33144 103 66858 08:16:12 CKPTINTVL 4800:0x1e3d4018 7.4 4.7 0.0 3 0.0 1.3 2.5 2231 476 882 2 587 1 66859 08:21:18 CKPTINTVL 4800:0x2518e018 6.8 6.6 0.0 1 0.0 0.0 0.0 58880 8985 1777 5 28401 93 66860 08:26:50 CKPTINTVL 4800:0x3810a018 31.7 22.8 0.0 12 0.7 5.5 8.7 58740 2574 2229 7 77847 247 66861 08:31:53 CKPTINTVL 4801:0x115ef018 3.3 2.5 0.0 3 0.0 0.7 0.7 4002 1607 3072 9 91569 283 66862 08:36:56 CKPTINTVL 4801:0x2b135018 3.4 3.2 0.0 2 0.0 0.1 0.1 3795 1179 3003 9 105348 347 66863 08:42:05 CKPTINTVL 4802:0x527e018 8.2 7.3 0.0 3 0.0 0.1 0.2 4574 628 2950 9 95045 312 66864 08:47:07 CKPTINTVL 4802:0x2127f018 2.8 2.4 0.0 2 0.0 0.0 0.0 5383 2279 3816 12 114755 372 66865 08:52:11 CKPTINTVL 4802:0x2c59f018 3.3 3.1 0.0 1 0.0 0.0 0.0 2914 939 1779 5 45973 151 66866 08:57:32 CKPTINTVL 4803:0x110018 20.5 17.7 0.0 5 0.0 1.5 2.8 3952 223 2477 8 68797 224 66867 09:02:42 CKPTINTVL 4803:0x15c87018 10.7 10.2 0.0 3 0.0 0.4 0.4 60253 5916 3504 11 89775 282 66868 09:07:49 CKPTINTVL 4803:0x25c97018 7.2 6.1 0.0 2 0.5 0.6 0.8 4002 652 3189 10 65988 212 66869 09:12:53 CKPTINTVL 4804:0xd31d0b4 4.0 3.8 0.0 3 0.0 0.1 0.1 5268 1369 4935 16 149330 486 66870 09:18:44 CKPTINTVL 4804:0x28723018 51.2 28.5 0.0 17 7.7 12.6 22.3 61141 2145 4777 14 111889 343 66871 09:24:00 CKPTINTVL 4804:0x3ac71018 45.2 30.8 0.0 7 4.8 8.8 13.3 60391 1957 4401 14 76697 244 66872 09:28:34 CKPTINTVL 4805:0x19792018 3.2 2.7 0.0 2 0.0 0.3 0.3 4920 1793 4367 14 113650 376 66873 09:34:00 CKPTINTVL 4805:0x2ae37018 26.3 25.4 0.0 4 0.1 0.7 0.7 60951 2395 3869 12 72243 238 66874 09:39:05 CKPTINTVL 4806:0x1039e018 5.5 5.2 0.0 3 0.0 0.3 0.3 6065 1172 5579 17 140850 432 66875 09:44:10 CKPTINTVL 4806:0x2d593018 4.8 4.4 0.0 2 0.0 0.3 0.3 5556 1266 4637 15 119350 390 66876 09:49:17 CKPTINTVL 4807:0x931d018 4.1 3.8 0.0 2 0.0 0.1 0.1 3845 1005 3528 11 102007 332 Max Plog Max Llog Max Dskflush Avg Dskflush Avg Dirty Blocked pages/sec pages/sec Time pages/sec pages/sec Time 10240 4907 1100 4 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 23244800 KB.