Database DB2 9.7.10 has the following bug:
"When you execute the Create DB, List db directory, backup command, the database is slow.
It05909:the commands accessing DB directory like create DB, List db directory could hang
Error 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 include create DB, connect to DB, List db
Directory etc.
The problem exists only in V9.7FP10.
The hang are due to wait on latch sqledircachelatch. One frequent
Symptom would be the following stack.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~
<<<< Waiter information (Address = 7800000002a1650) >>>>
Total Waiters >> 4
File Information:
line:59, File:sqledcle. C
----------------------------
PID (s):
19668 (./21626912.19668.000.stack.txt)--line:59, File:
Sqledcle. C (Sqlo_lt_sqle_krcb__sqledircachelatch)
Agent type:db2agent ()
<<< Stack >>>
timestamp:2014-11-24-16.35.04.919649
0x090000000a7fbb64 [email protected] + 0x8c
0x090000000a7fb90c Sqloxlatchconflict + 0x1cc
0x090000000a7fb67c [email protected] + 0x78
0x090000000d137084 SQLEGETDIRCACHELATCH__FV + 0x68
0x090000000aa00544 Sqlehdir__fp8sqle_bwa + 0x13c
0x090000000aa643dc
Sqleucconnectdirlookup__fp8sqeagentp14db2ucconhandle + 0xC0
0x090000000aa823d8
@[email PROTECTED]__FP8SQEAGENTP14DB2UCCONHANDLEPB + 0x1f4
0x090000000aa81d78
@[email Protected]__fp8sqeagentp18sqlcc_initstruct_tp14db2ucconh
ANDLEPBPPC + 0X2F4
0x090000000aa8106c
@[email PROTECTED]__FP18SQLCC_INITSTRUCT_TB + 0x234
0x090000000aa80b7c sqljsdrdaasdriver__fp18sqlcc_initstruct_t +
0xEC
0x090000000a9ea5d8 RUNEDU__8SQEAGENTFV + 0x2f0
0x090000000a9e7c34 EDUDRIVER__9SQZEDUOBJFV + 0xE4
0x090000000a72a1a0 Sqloeduentry + 0x250
Local fix
DB2 update dbm CFG using Dir_cache No
Db2set Db2ldapcache=no
The issue of DB2 9.7.10 reported by the CBRC