home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC66966 Status: Geschlossen

CRASH RECOVERY FAILURE IN SQLPGSWITCHFROMREDOTOUNDO, PROBE:1820 WITH
MESSAGE : "FILE COUNT <= TAILINDEX"

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
Crash recovery may fail if during crash recovery, the next Log 
Sequence Number ( LSN ) is pointing to a log file that has not 
yet been allocated or is no longer available on the system. This 
condition is rare, as normally log files are pre-allocated. 
The db2diag.log will show messages like : 
 
2010-03-05-13.01.08.442116+000 I4808A363          LEVEL: Error 
PID     : 24295                TID  : 16          PROC : db2sysc 
0 
INSTANCE: db2inst3             NODE : 000         DB   : SAMPLE 
EDUID   : 16                   EDUNAME: db2loggr (SAMPLE) 0 
FUNCTION: DB2 UDB, recovery manager, sqlpgSwitchFromRedoToUndo, 
probe:1820 
MESSAGE : File Count <= TailIndex 
 
2010-03-05-13.01.08.442614+000 I5172A168          LEVEL: Error 
PID:24295 TID:16 NODE:000 Title: SQLP_DBCB 
Dump File:/home/db2inst3/sqllib/db2dump/24295.16.000.dump.bin
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Crash recovery may incorrectly fail with a message saying    * 
* File Count <= TailIndex                                      * 
* There is no preventative measures for this apar, although    * 
* the conditions to encounter this problem are rare.           * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade the db2 server code to Fix Pack <x>                  * 
****************************************************************
Local-Fix:
DB2 Service may be able to patch the log control file to 
circumvent the code path.
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
The problem will be fixed in V9.7 Fix Pack k <x>
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC67307 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
08.03.2010
10.06.2010
10.06.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.
Problem behoben lt. FixList in der Version
9.7.0.2 FixList