DB2 - Problembeschreibung
Problem IT05909 | Status: Geschlossen |
COMMANDS ACCESSING DB DIRECTORY ( "CREATE DB", "LIST DB DIRECTORY", ETC) MAY HANG | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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 | |
Lösung | |
10.1xx, 10.5xx Commands accessing database directory like db2 list db directory, create db etc will not hang | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 04.12.2014 05.10.2015 05.10.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
9.7.0.11 |