Specifying the interval for detecting deadlocks
You can specify the interval for how often Db2 scans for deadlocked processes.
About this task
Deadlock detection can cause latch suspensions.
Procedure
To specify the interval for detecting deadlocks:
Specify a value in seconds for the DEADLOCK TIME field on installation panel DSNTIPJ.
- For systems in which deadlocking is not a problem, have deadlock detection run less frequently for the best performance and concurrency (but do not choose a value greater than 5 seconds).
- If your system is prone to deadlocks, you want those detected as quickly as possible. In that case, choose 1.
The default value of the DEADLOCK TIME field is 1 second.