The issue of DB2 9.7.10 reported by the CBRC

Source: Internet
Author: User
Tags access database


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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.