背景与环境:
现场信息:
Database Lock Snapshot
Database name = ZBBB
Database path = /db2data/db2inst1/NODE0000/SQL00001/MEMBER0000/
Input database alias = ZBBB
Locks held = 295
Applications currently connected = 161
Agents currently waiting on locks = 0
Snapshot timestamp = 05/05/2018 11:06:08.916275
Application handle = 10641
Application ID = 172.20.2.2.65000.180824194601
Sequence number = 00001
Application name = db2jcc_application
CONNECT Authorization ID = USERDBS
Application status = UOW Executing
Status change time = Not Collected
Application code page = 1208
Locks held = 292
Total wait time (ms) = Not Collected
List Of Locks
Lock Name = 0x0000000300000001000130A0D6
Lock Attributes = 0x00000000
Release Flags = 0x40000000
Lock Count = 1
Hold Count = 0
Lock Object Name = 0
Object Type = Internal Variation Lock
Mode = S
Lock Name = 0x000500060000000072CB000652
Lock Attributes = 0x00000008
Release Flags = 0x40000000
Lock Count = 1
Hold Count = 0
Lock Object Name = 1925906438
Object Type = Row
Tablespace Name = MHAPPLOB
Table Schema = MHAPP
Table Name = RPT01_CAC
Mode = X
Lock Name = 0x000500060000000072CB000552
Lock Attributes = 0x00000008
Release Flags = 0x40000000
Lock Count = 1
Hold Count = 0
Lock Object Name = 1925906437
Object Type = Row
Tablespace Name = MHAPPLOB
Table Schema = MHAPP
Table Name = RPT01_CAC
Mode = X
Lock Name = 0x00040005000000004601000452
Lock Attributes = 0x00000008
Release Flags = 0x40000000
Lock Count = 1
Hold Count = 0
Lock Object Name = 1174470660
Object Type = Row
Tablespace Name = MHAPPGEN
Table Schema = MHAPP
Table Name = ELE01_SASP
Mode = X
Lock Name = 0x000500060000000072CB000452
Lock Attributes = 0x00000008
Release Flags = 0x40000000
Lock Count = 1
Hold Count = 0
Lock Object Name = 1925906436
Object Type = Row
Tablespace Name = MHAPPLOB
Table Schema = MHAPP
Table Name = RPT01_CAC
Mode = X
Lock Name = 0x00040005000000004601000352
Lock Attributes = 0x00000008
Release Flags = 0x40000000
Lock Count = 1
Hold Count = 0
Lock Object Name = 1174470659
Object Type = Row
Tablespace Name = MHAPPGEN
Table Schema = MHAPP
Table Name = ELE01_SASP
Mode = X
Lock Name = 0x000500060000000072CB000352
Lock Attributes = 0x00000008
Release Flags = 0x40000000
Lock Count = 1
Hold Count = 0
Lock Object Name = 1925906435
Object Type = Row
Tablespace Name = MHAPPLOB
Table Schema = MHAPP
Table Name = RPT01_CAC
Mode = X
Lock Name = 0x00040005000000004601000252
Lock Attributes = 0x00000008
Release Flags = 0x40000000
Lock Count = 1
Hold Count = 0
Lock Object Name = 1174470658
Object Type = Row
Tablespace Name = MHAPPGEN
Table Schema = MHAPP
Table Name = ELE01_SASP
Mode = X
Lock Name = 0x000500060000000072CB000252
Lock Attributes = 0x00000008
Release Flags = 0x40000000
Lock Count = 1
Hold Count = 0
Lock Object Name = 1925906434
Object Type = Row
Tablespace Name = MHAPPLOB
Table Schema = MHAPP
Table Name = RPT01_CAC
Mode = X
......后面还有很多
db2diag.log中无报错信息;插入事务的程序工程师反映其在插入数据库后,确实做过了主动commit。
问题:
现阶段,我不知道该继续收集那些信息,如何判断瓶颈在何处。
请老师多多指教