能否详细解析一下如何查看这些位于db2dump中的logtimeout文件?

我设置的DB CFG locktimeout是-1

Max storage for lock list (4KB) (LOCKLIST) = AUTOMATIC(942038) AUTOMATIC(942038)
Percent. of lock lists per application (MAXLOCKS) = AUTOMATIC(97) AUTOMATIC(97)
Interval for checking deadlock (ms) (DLCHKTIME) = 10000 10000
Lock timeout (sec) (LOCKTIMEOUT) = -1 -1
Block log on disk full (BLK_LOG_DSK_FUL) = NO NO
Block non logged operations (BLOCKNONLOGGED) = YES YES
Lock timeout events (MON_LOCKTIMEOUT) = NONE NONE
Deadlock events (MON_DEADLOCK) = WITHOUT_HIST WITHOUT_HIST
Lock wait events (MON_LOCKWAIT) = NONE NONE
Lock wait event threshold (MON_LW_THRESH) = 5000000 5000000
Lock event notification level (MON_LCK_MSG_LVL) = 1 1

以下report就是生成的db2 locktimeout文件,为什么lock timeout是2000 micro seconds呢?
LOCK TIMEOUT REPORT

Date: 24/05/2018
Time: 18:39:28
Instance: db2inst1
Database: PRODTDB
Member ID: 0

Lock Information:

Lock Name: 0060000400000094207E001652
Lock Type: Basic RECORD lock(DMS/IXM)
Lock Specifics: (obj={96;4}, rid=d(0;9707646;22), x00000094207E0016)

Lock Requestor:
System Auth ID: PRODTDBUSR
Application Handle: [0-7304]
Application ID: 10.2.50.54.55350.180524103921
Application Name: /home/ii-mail-PRODTDB/
Requesting Agent ID: 186926
Coordinator Agent ID: 186926
Coordinator Partition: 0
Lock timeout Value: 2000 milliseconds
Lock mode requested: ..U
Application Status: (SQLM_LOCKWAIT)
Current Operation: (SQLM_EXECUTE)
Lock Escalation: No

Context of Lock Request:
Identification: UOW ID (8); Activity ID (3)
Activity Information:

  Package Schema:         (NULLID  )
  Package Name:           (SYSSH200NULLID  )
  Package Version:        ()
  Section Entry Number:   9
  SQL Type:               Dynamic
  Statement Type:         DML, Insert/Update/Delete
  Effective Isolation:    Cursor Stability
  Statement Unicode Flag: No
  Statement:              UPDATE service_property   SET (value, last_modified) = ('Processing', current_timestamp)   WHERE     oid = ?
AND value = 'Pending'

Lock Owner (Representative):
System Auth ID: PRODTDBUSR
Application Handle: [0-28260]
Application ID: 10.2.50.110.39124.180524103855
Application Name: modify.cgi hartman .
Requesting Agent ID: 189237
Coordinator Agent ID: 189237
Coordinator Partition: 0
Lock mode held: ..X

List of Active SQL Statements: Not available

List of Inactive SQL Statements from current UOW: Not available

参与11

2同行回答

DB-TrendSetterDB-TrendSetter联盟成员数据库架构师公司
locktimeout文件主要分为两个部分,lock请求者和占用着,非常直观,针对LOCKTIMEOUT=2000毫秒问题,建议查看app server中是否有限制。显示全部

locktimeout文件主要分为两个部分,lock请求者和占用着,非常直观,针对LOCKTIMEOUT=2000毫秒问题,建议查看app server中是否有限制。

收起
电信运营商 · 2018-05-25
flywiththewindflywiththewind其它easy world
lock owner导致了lock requesterstatement为sql如果sql为空,能能是static sql 一起学习~~显示全部

lock owner导致了lock requester

statement为sql
如果sql为空,能能是static sql
一起学习~~

收起
系统集成 · 2018-05-25
浏览2233

提问者

steve25
数据库管理员IBM

问题来自

相关问题

相关资料

相关文章

问题状态

  • 发布时间:2018-05-24
  • 关注会员:3 人
  • 问题浏览:5220
  • 最近回答:2018-05-25
  • X社区推广