我设置的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