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 IC91640 Status: Geschlossen

DB2 INSTANCE MIGHT CRASH DUE TO INVALID TRANSACTION STATE AFTER ONLINE
TABLESPACE ROLLFORWARD

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
DB2 instance might crash in certain cases where online 
tablespace rollforward is done, due to invalid transaction 
state. 
The problem is likely to be encountered when online tablespace 
rollforward is used, and a transaction manager function is 
called in the wrong context. 
 
Diagnostics eye-catcher entries in the db2diag.log may look like 
this - 
 
2012-12-21-16.37.21.284387-300 I148925865A601     LEVEL: Severe 
PID     : 10158226             TID  : 76994       PROC : db2sysc 
1 
INSTANCE: db2stp               NODE : 001         DB   : 
SAMPLEDB 
APPHDL  : 0-11972              APPID: 
192.111.44.22.37720.121221210920 
AUTHID  : DB2STP 
EDUID   : 76994                EDUNAME: db2agnta (SAMPLEDB) 1 
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, 
probe:250 
RETCODE : ZRC=0x80100027=-2146435033=SQLP_PROTO 
          "Transaction manager function called in wrong 
context." 
          DIA8039C XA error with request type of "". XA protocol 
error. 
 
Another example of a db2diag.log entry seen in this problem - 
 
2012-12-21-16.37.21.237622-300 I148900675A600     LEVEL: Error 
PID     : 10158226             TID  : 76994       PROC : db2sysc 
1 
INSTANCE: db2stp               NODE : 001         DB   : 
SAMPLEDB 
APPHDL  : 0-11972              APPID: 
192.111.43.11.37720.121221210920 
AUTHID  : DB2STP<< 
EDUID   : 76994                EDUNAME: db2agnta (SAMPLEDB) 1 
FUNCTION: DB2 UDB, data protection services, sqlpxrbk, 
probe:2320 
RETCODE : ZRC=0x80100027=-2146435033=SQLP_PROTO 
          "Transaction manager function called in wrong 
context." 
          DIA8039C XA error with request type of "". XA protocol 
error.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW version 9.7 Fix Pack 9                    * 
****************************************************************
Local-Fix:
Uae offline tablespace rollforward
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
This is fixed in DB2 LUW version 9.7 Fix Pack 9.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
17.04.2013
16.12.2013
16.12.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP9
Problem behoben lt. FixList in der Version
9.7.0.9 FixList
9.7.0.9 FixList