DEADLOCK_TIMEOUT configuration parameter
Use the DEADLOCK_TIMEOUT configuration parameter to specify the maximum number of seconds that a database server thread can wait to acquire a lock.
Use this parameter only for distributed queries that involve a remote database server. Do not use this parameter for nondistributed queries.
- onconfig.std value
- DEADLOCK_TIMEOUT 60
- values
- Positive integers
- units
- Seconds
- takes effect
- After you edit your onconfig file and restart the database server.
Usage
If a distributed transaction is forced to wait longer than the number of seconds specified with the DEADLOCK_TIMEOUT configuration parameter, the thread that owns the transaction assumes that a multi-server deadlock exists.