|
Problem IT05909
|
Status: Closed |
COMMANDS ACCESSING DB DIRECTORY ( "CREATE DB", "LIST DB DIRECTORY", ETC) MAY HANG |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
If the dbm cfg parameter dir_cache is set to yes(default),
commands that access database directory files i.e sqldbdir may
hang.
Such commands may include create db, connect to db, list db
directory etc.
This problem exists only in DB2 version 9.7 fix pack 10.
The hang is due to wait on latch
SQLO_LT_SQLE_KRCB__sqleDirCacheLatch. One frequent symptom would
be the following stack:
thread_waitlock
sqloXlatchConflict
sqloXlatchConflict
sqleGetDirCacheLatch
sqlehdir
sqleUCconnectDirLookup
sqljsVerifyAgent
sqljsInitAgent
sqljsDrdaAsInnerDriver
sqljsDrdaAsDriver
RunEDU
EDUDriver
sqloEDUEntry |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 10.1xx, 10.5xx *
**************************************************************** |
| Local Fix: |
db2 update dbm cfg using dir_cache no
db2set DB2LDAPCACHE=NO |
| Solution |
10.1xx, 10.5xx
Commands accessing database directory like db2 list db
directory, create db etc will not hang |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 04.12.2014
05.10.2015
05.10.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.11
|
 |
