[informix@localhost ~]$ onstat -g ckpIBM Informix Dynamic Server Version 11.70.UC2 -- On-Line -- Up 04:29:07 -- 174176 KbytesAUTO_CKPTS=On RTO_SERVER_RESTART=Off  ...
显示全部[informix@localhost ~]$ onstat -g ckp
IBM Informix Dynamic Server Version 11.70.UC2 -- On-Line -- Up 04:29:07 -- 174176 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
1516 15:32:33 Startup 1452:0x340b0 0.4 0.3 0.0 0 0.0 0.0 0.0 21 21 21 0 1 0
1517 15:43:47 *Backup 1452:0x66018 0.3 0.0 0.0 0 0.1 0.0 0.0 13 13 38 0 50 0
1518 15:43:48 Backup 1452:0x68158 0.1 0.0 0.0 0 0.0 0.0 0.0 0 0 0 0 2 2
1519 16:09:05 CKPTINTVL 1452:0x79018 0.8 0.4 0.0 0 0.0 0.0 0.0 31 31 18 0 17 0
1520 16:34:07 CKPTINTVL 1452:0x81018 0.1 0.1 0.0 0 0.0 0.0 0.0 12 12 20 0 8 0
1521 16:59:10 CKPTINTVL 1452:0x86018 0.2 0.0 0.0 0 0.0 0.0 0.0 12 12 19 0 5 0
1522 17:24:17 CKPTINTVL 1452:0xbd018 4.4 3.7 0.0 0 0.0 0.0 0.0 95 25 111 0 55 0
1523 17:49:20 CKPTINTVL 1452:0xc5018 0.2 0.1 0.0 0 0.0 0.0 0.0 13 13 21 0 8 0
1524 18:14:22 CKPTINTVL 1452:0xd2018 0.8 0.6 0.0 0 0.0 0.0 0.0 20 20 25 0 13 0
1525 18:39:24 CKPTINTVL 1452:0xd4018 0.3 0.1 0.0 0 0.0 0.0 0.0 1 1 9 0 2 0
1526 19:04:27 CKPTINTVL 1452:0xe2018 0.2 0.1 0.0 0 0.0 0.0 0.0 16 16 15 0 14 0
1527 19:29:29 CKPTINTVL 1452:0xe4018 0.1 0.0 0.0 0 0.0 0.0 0.0 1 1 8 0 2 0
1528 19:54:31 CKPTINTVL 1452:0xe6018 0.0 0.0 0.0 0 0.0 0.0 0.0 1 1 2 0 2 0
Max Plog Max Llog Max Dskflush Avg Dskflush Avg Dirty Blocked
pages/sec pages/sec Time pages/sec pages/sec Time
200 200 4 11 0 0
然后具体问题具体分析;P
收起