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 |