|
Problem IT00454
|
Status: Closed |
OPENING A RAW DMS CONTAINER HAVING FILE SYSTEM CACHING CAN CRASH THE DB2 INSTANCE. |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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. |
| available fix packs: |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
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 |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 20.03.2014
25.07.2016
25.07.2016 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.4
|
 |
