IT咨询服务DPFDb2 10.5

db2 dpf v10.5,用event monitor for locking 抓取lock event,数据报“Activities not available”?

配置过程:
db2 " connect to edwdb "
db2 " update db cfg using MON_LOCKTIMEOUT HIST_AND_VALUES MON_DEADLOCK HIST_AND_VALUES MON_LOCKWAIT HIST_AND_VALUES MON_LW_THRESH 10000000 "
db2 " create event monitor lockevm for locking write to unformatted event table "
db2 " set event monitor lockevm state 1 "

解析语句:
/db2home/db2iedw/sqllib/java/jdk64/bin/java db2evmonfmt -d edwdb -ue db2iedw.lockevm -ftext -u db2iedw -p db2iedw -hours 24 >> /tmp/lockevent.20190227.out

lockevent.20190227.out里面信息(例):

Event ID : 142
Event Type : LOCKWAIT
Event Timestamp : 2019-02-27-11.05.16.068336

Partition of detection : 23

Participant No 1 requesting lock

Lock Name : 0x0600000000000000000000004F
Lock wait start time : 2019-02-27-11.05.06.069569
Lock wait end time : 2019-02-27-11.05.24.258032
Lock Type : OBJECT_TABLE
Lock Specifics :
Lock Attributes : 00200000
Lock mode requested : Share
Lock mode held : Intent Exclusive
Lock Count : 0
Lock Hold Count : 0
Lock rrIID : 0
Lock Status : Granted
Lock release flags : 00000000
Tablespace TID : 6
Tablespace Name : USERDATA
Table FID :
Table Schema :
Table Name :

1wxcgn1f94w

1wxcgn1f94w

Current Activities of Participant No 1

Activities not available

Past Activities of Participant No 1

Activities not available

Current Activities of Participant No 2

Activities not available

Past Activities of Participant No 2

Activities not available

参与7

1同行回答

anikikonganikikong课题专家组数据库运维工程师中国民生银行
实例里面的相关监视器打开了吗显示全部

实例里面的相关监视器打开了吗

收起
银行 · 2019-03-09
  • 打开了
    2019-04-26
  • 这种情况像是占锁的sql不是上一条,而是事务之前的,后面的sql都已经跑完了,但是不提交,会导致看不到sql,但是锁还占着
    2019-05-10

提问者

windy
数据库管理员KSRCB

相关问题

问题状态

  • 发布时间:2019-03-01
  • 关注会员:2 人
  • 问题浏览:2513
  • 最近回答:2019-03-09
  • X社区推广