• Admin-Scout-small-Banner
           
    CURSOR Admin-Scout
    get the ultimate tool for Informix
    pfeil  
invispix 10x10
invispix 10x10
Latest versionsfixlist
14.10.xC5 FixList
12.10.xC14.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

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)
invispix 10x10
invispix 10x10
invispix 10x10
Technical InfoTechnical Info

Technical Info

DocumentationDocumentation

Documentation

IBM NewsletterIBM Newsletter

IBM Newsletter

Current BugsCurrent Bugs

Current Bugs

Bug ResearchBug Research

Bug Research

Bug FixlistsBug Fixlists

Bug Fixlists

Release NotesRelease Notes

Release Notes

Machine NotesMachine Notes

Machine Notes

Release NewsRelease News

Release News

Product LifecycleProduct Lifecycle

Lifecycle

Media DownloadMedia Download

Media Download

invispix 10x10
Service und SupportService und Support

Service and Support

Informix MonitoringInformix Monitoring

Informix Monitoring

Admin-Scout forInformixAdmin-Scout forInformix

Admin-Scout for Informix

Informix News & InfosInformix News & Infos

Informix News & Infos

This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.