|
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) |
