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 | |
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 | |
9.7.0.9 |