DB2 - Problembeschreibung
Problem IT00454 | Status: Geschlossen |
OPENING A RAW DMS CONTAINER HAVING FILE SYSTEM CACHING CAN CRASH THE DB2 INSTANCE. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
db2diag.log might have entries like : 2014-02-28-13.59.36.128619+480 I288773A611 LEVEL: Severe PID : 10617064 TID : 10831 PROC : db2sysc 0 INSTANCE: DB2INST1 NODE : 000 DB : DB2INST1DB APPHDL : 0-112 APPID: *LOCAL.DB2INST1.140228054746 AUTHID : DB2INST1 HOSTNAME: MACHINE1 EDUID : 10831 EDUNAME: db2agent (DB2INST1DB) 0 FUNCTION: DB2 UDB, Common Trace API, sqlbfix, probe:2629 DATA #1 : String, 59 bytes no SQLB_OPEN_OPTS_REQUIRE_SYNC should be set for raw device DATA #2 : Hexdump, 4 bytes 0x0A00000007BF3850 : 0000 0002 Callstack of crashing EDU might look like : pthread_kill _p_raise raise abort sqloExitEDU sqle_panic sqlb_panic sqlbDMSOpenContainer sqlbDMSOpenContainer SqlbFhdlRec::openDMSFile sqlbDMSGetOpenInfo sqldCompleteAsyncWrite sqldCompleteAsyncWrite sqluFlushBufferedIO sqluDoPhysicalConsistencyPt sqluDoConsistencyPt squInitTableObjects sqluCFormatter::iRun sqluLoadEDUDriver sqloEDUEntry | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Cancun Release 10.5.0.4 and disable file * * system caching on existing raw devices. * **************************************************************** | |
Local-Fix: | |
This fix will disable the ability to enable file system caching for raw devices in the "CREATE TABLESPACE" and "ALTER TABLESPACE" commands. For existing raw devices file system caching must be manually disabled. | |
verfügbare FixPacks: | |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows | |
Lösung | |
db2diag.log might have entries like : 2014-02-28-13.59.36.128619+480 I288773A611 LEVEL: Severe PID : 10617064 TID : 10831 PROC : db2sysc 0 INSTANCE: DB2INST1 NODE : 000 DB : DB2INST1DB APPHDL : 0-112 APPID: *LOCAL.DB2INST1.140228054746 AUTHID : DB2INST1 HOSTNAME: MACHINE1 EDUID : 10831 EDUNAME: db2agent (DB2INST1DB) 0 FUNCTION: DB2 UDB, Common Trace API, sqlbfix, probe:2629 DATA #1 : String, 59 bytes no SQLB_OPEN_OPTS_REQUIRE_SYNC should be set for raw device DATA #2 : Hexdump, 4 bytes 0x0A00000007BF3850 : 0000 0002 Callstack of crashing EDU might look like : pthread_kill _p_raise raise abort sqloExitEDU sqle_panic sqlb_panic sqlbDMSOpenContainer sqlbDMSOpenContainer SqlbFhdlRec::openDMSFile sqlbDMSGetOpenInfo sqldCompleteAsyncWrite sqldCompleteAsyncWrite sqluFlushBufferedIO sqluDoPhysicalConsistencyPt sqluDoConsistencyPt squInitTableObjects sqluCFormatter::iRun sqluLoadEDUDriver sqloEDUEntry This fix will disable the ability to enable file system caching for raw devices in the "CREATE TABLESPACE" and "ALTER TABLESPACE" commands. For existing raw devices file system caching must be manually disabled. First fixed in DB2 Cancun Release 10.5.0.4. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 20.03.2014 25.07.2016 25.07.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.4 |