home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
15.0.xC1.2 FixList
14.10.xC13.3 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

Informix - Problembeschreibung

Problem IT09615 Status: Geschlossen

MANY LONGTX CHECKPOINTS BEING SEEN WITH SMALL TRANSACTIONS COVERING ONLY A
FEW LOGS WHEN THE WORK IS ROLLED BACK

Produkt:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problembeschreibung:
ENV:  11.50.FC3 LINUX & 11.50.FC5W1 ON SOLARIS. 
 
The following is being seen when running an onstat -g ckp report 
... 
 
66025      17:36:56  LongTX     2787:0x4343018    0.6   0.6 
0.0   0      0.0   0.0   0.0   3109      3109    2920     21 
2444     17 
66026      17:37:40  LongTX     2787:0x4792018    0.4   0.3 
0.0   1      0.0   0.0   0.0   1723      1723    1516     34 
1110     25 
66027      17:43:10  CKPTINTVL  2787:0x5ff3018    1.7   1.3 
0.0   0      0.0   0.0   0.0   5741      4449    4623     14 
6267     19 
66028      17:43:58  LongTX     2787:0x64c7018    0.3   0.3 
0.0   2      0.0   0.0   0.0   1608      1608    1861     37 
1247     25 
66029      17:49:10  CKPTINTVL  2787:0x814f018    2.0   1.8 
0.0   2      0.0   0.0   0.0   6289      3478    5149     16 
7346     23 
66030      17:51:20  LongTX     2787:0x8b7c018    0.6   0.5 
0.0   0      0.0   0.0   0.0   3246      3246    3339     25 
2618     19 
66031      17:56:40  CKPTINTVL  2787:0x9ff8018    1.7   1.3 
0.0   0      0.0   0.0   0.0   5262      4141    4685     14 
5274     16 
66032      17:57:28  LongTX     2787:0xa2f8018    0.3   0.2 
0.0   0      0.0   0.0   0.0   1600      1600    1652     33 
771      15 
66033      17:59:04  LongTX     2787:0xa899018    0.3   0.3 
0.0   0      0.0   0.0   0.0   1795      1795    1899     19 
1452     15 
66034      17:59:05  LongTX     2787:0xa8b8018    0.1   0.0 
0.0   0      0.0   0.0   0.0   115       115     472      472 
32       32 
 
The checkpoint interval is 300 (5 minutes) but what is seen is 
many LongTX checkpoints between these and some are only a few 
seconds apart.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of 12.10                                               * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IBM Informix Server 12.10.xC6                      * 
****************************************************************
Local-Fix:
Lösung
Problem Fixed In IBM Informix Server 12.10.xC6
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
23.06.2015
19.01.2016
19.01.2016
Problem behoben ab folgender Versionen (IBM BugInfos)
12.10.xC6
Problem behoben lt. FixList in der Version
12.10.xC6 FixList