Checkpoint statistics

Hello all, I am posting the checkpoint statistics output below onstat -g ckp IBM Informix Dynamic Server Version 12.10.FC6 -- On-Line -- Up 2 days 07:38:02 -- 5318400 Kbytes AUTO_CKPTS=On RTO_SERVER_RESTART=60 seconds Estimated recovery time 23 seconds 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 94080 13:27:05 RTO 53638:0x1b27b018 5.1 0.0 0.0 0 0.0 0.0 0.0 402 402 404 80 5463 1092 94081 13:27:10 RTO 53638:0x1c842018 4.9 2.6 0.0 0 0.0 0.0 0.0 420 162 414 82 5595 1119 94082 13:27:15 RTO 53638:0x1dc9d018 7.3 1.4 0.0 1 4.0 0.1 0.1 393 278 398 79 5231 1046 94083 13:27:20 RTO 53639:0xff018 16.5 1.6 0.0 0 0.0 0.0 0.0 263 163 270 54 3242 648 94084 13:56:49 RTO 53639:0x2de9018 419.6 0.0 0.0 3 0.1 1.8 4.5 3470 3470 3117 1 11781 6 94085 13:56:54 RTO 53639:0x6f45018 186.2 0.0 0.0 1 0.0 3.9 3.9 1305 1305 1452 290 17745 3549 94086 13:56:55 RTO 53639:0x733c018 565.7 0.6 0.0 5 0.0 456.1 519.0 91 91 82 82 1892 1892 94087 13:57:00 RTO 53639:0x8269138 103.8 1.9 0.0 0 0.0 0.0 0.0 368 198 338 67 3885 777 94088 14:00:51 RTO 53639:0x862c018 558.5 0.0 0.0 1 0.0 0.1 0.1 587 587 470 2 963 4 94089 14:26:11 RTO 53639:0x8d7f018 436.7 0.0 0.0 0 0.0 0.0 0.0 971 971 917 0 1875 1 94090 14:26:47 RTO 53639:0x9555200 138.8 0.0 0.0 1 0.0 3.5 3.5 2020 2020 2251 62 2197 61 94091 14:26:52 RTO 53639:0xa885184 4.1 2.2 0.0 1 0.0 0.3 0.3 517 230 535 107 4933 986 94092 14:26:57 RTO 53639:0xc063018 5.6 2.0 0.0 1 1.4 0.2 0.2 443 224 449 89 6134 1226 94093 14:27:02 RTO 53639:0xcfa2018 5.7 1.6 0.0 1 1.5 0.5 0.5 292 183 298 59 3927 785 94094 14:27:07 RTO 53639:0xf7f9018 7.2 0.0 0.0 1 1.7 0.2 0.2 755 755 770 154 10358 2071 94095 14:27:12 RTO 53639:0x10bcf018 4.1 1.7 0.0 0 0.0 0.0 0.0 383 222 389 77 5078 1015 94096 14:35:38 RTO 53639:0x110cf018 345.5 0.0 0.0 0 0.0 0.0 0.0 549 549 396 0 1280 2 94097 14:36:33 RTO 53639:0x11471018 74.0 0.0 0.0 0 0.0 0.0 0.0 129 129 331 6 930 16 94098 14:36:49 RTO 53639:0x11889018 26.1 0.5 0.0 0 0.0 0.0 0.0 31 31 100 6 1048 65 94099 14:50:22 RTO 53639:0x11cde018 664.6 0.0 0.0 0 0.0 0.0 0.0 681 681 616 0 1110 1 Max Plog Max Llog Max Dskflush Avg Dskflush Avg Dirty Blocked pages/sec pages/sec Time pages/sec pages/sec Time 5120 640 3 838 0 0 The physical log size is smaller than the recommended size for a server configured with RTO_SERVER_RESTART. Fast recovery performance might not be optimal. For best fast recovery performance when RTO_SERVER_RESTART is enabled, increase the physical log size to at least 2083356 KB. For servers configured with a large buffer pool, this might not be necessary. See the Administrator's Guide for more information. can anyone help me on this, why the total time is taking more? Version : IDS 12.10FC6 OS : Windows 2012R2

Hello. A simple google search about Informix RTO would bring you this page, that explains everything in details about this feature, I think: https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.perf.doc/id s_prf_244.htm Please take a look, and if you have some more specific doubt, ask again. HTH Alexandre Marini