Informix - Problem description
Problem IT29861 | Status: Closed |
CHECKPOINT DECISION IS BASED ON PEAK VALUES WHICH LEAD TO CHECKPOINTS AT LOG SWITCHES WHICH DO NOT NEED TO BE | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
On a very long running customer system , the system was up 99 days and has 600 logs with 100000 pages each at every logswitch an checkpoint is taken. The following onstat is taken from the system: onstat -g ckp IBM Informix Dynamic Server Version 12.10.FC9 -- On-Line -- Up 98 days 07:02:38 -- 50579456 Kbytes AUTO_CKPTS=Off 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 1612230 09:05:49 Llog 1167702:0x244 0.3 0.2 0.3 52 0.0 0.2 0.3 15304 15304 176027 1431 100000 813 1612231 09:07:52 Llog 1167703:0x918 0.4 0.3 0.4 11 0.0 0.4 0.4 14956 14956 176844 1437 100000 813 1612232 09:09:54 Llog 1167704:0x768 0.2 0.2 0.2 15 0.0 0.2 0.2 14918 14918 176185 1432 100000 813 1612233 09:12:01 Llog 1167705:0x580 0.2 0.2 0.2 16 0.0 0.2 0.2 15134 15134 175802 1384 100000 787 1612234 09:14:05 Llog 1167706:0x214 0.3 0.2 0.3 17 0.0 0.2 0.3 15298 15298 175362 1414 100000 806 1612235 09:16:09 Llog 1167707:0xac 0.2 0.2 0.2 14 0.0 0.2 0.2 15394 15394 174430 1406 100000 806 1612236 09:18:12 Llog 1167708:0x154 0.2 0.2 0.2 11 0.0 0.2 0.2 14773 14773 170428 1396 100000 819 1612237 09:20:12 Llog 1167709:0x37c 0.2 0.2 0.2 8 0.0 0.2 0.2 15685 15685 167632 1396 100000 833 1612238 09:22:11 Llog 1167710:0x58 0.2 0.1 0.2 13 0.0 0.2 0.2 15098 15098 171571 1429 100000 833 1612239 09:24:10 Llog 1167711:0x244 0.3 0.3 0.3 10 0.0 0.3 0.3 15069 15069 166911 1414 100000 847 1612240 09:26:10 Llog 1167712:0x60 0.3 0.3 0.3 12 0.0 0.3 0.3 14990 14990 165008 1363 100000 826 1612241 09:28:05 Llog 1167713:0x48 0.2 0.1 0.2 20 0.0 0.1 0.2 15202 15202 155463 1351 100000 869 1612242 09:29:48 Llog 1167714:0x9f8 0.2 0.2 0.2 21 0.0 0.2 0.2 15415 15415 155099 1505 100000 970 1612243 09:31:30 Llog 1167715:0x1920 0.2 0.2 0.2 10 0.0 0.2 0.2 15020 15020 153027 1515 100000 990 1612244 09:33:21 Llog 1167716:0x444 0.2 0.2 0.2 13 0.0 0.2 0.2 15185 15185 142750 1274 99999 892 1612245 09:35:07 Llog 1167717:0x378 0.4 0.4 0.4 9 0.0 0.4 0.4 14979 14979 157493 1485 100000 943 1612246 09:36:59 Llog 1167718:0x6e0 0.3 0.2 0.3 12 0.0 0.2 0.3 15227 15227 149768 1337 100000 892 1612247 09:38:52 Llog 1167719:0x50 0.1 0.1 0.1 10 0.0 0.1 0.1 14571 14571 158585 1403 100000 884 1612248 09:40:59 Llog 1167720:0x58 0.2 0.2 0.2 6 0.0 0.2 0.2 14861 14861 172391 1357 100000 787 1612249 09:43:03 Llog 1167721:0x208 0.3 0.3 0.3 12 0.0 0.3 0.3 15263 15263 171466 1382 100000 806 Max Plog Max Llog Max Dskflush Avg Dskflush Avg Dirty Blocked pages/sec pages/sec Time pages/sec pages/sec Time 10533 21476703 100 3475 25 4 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS version prior to 12.10.xC14. * **************************************************************** * PROBLEM DESCRIPTION: * * Checkpoint decision is based on peak values which lead to * * checkpoints at log switches which do not need to be. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 29.07.2019 20.09.2019 19.02.2020 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC14 | |
Problem solved according to the fixlist(s) of the following version(s) |