Cloudscape Properties
Page 26 of 47

cloudscape.locks.deadlockTimeout

Function

Determines the number of seconds after which Cloudscape checks whether a transaction waiting to obtain a lock is involved in a deadlock. If a deadlock has occurred, and Cloudscape chooses the transaction as a deadlock victim, Cloudscape aborts the transaction. The transaction receives an SQLException of SQLState 40001. If the transaction is not chosen as the victim, it continues to wait for a lock if cloudscape.locks.waitTimeout is set to a higher value than the value of cloudscape.locks.deadlockTimeout.

If this property is set to a higher value than cloudscape.locks.waitTimeout, no deadlock checking occurs. See cloudscape.locks.waitTimeout.

For more information about deadlock checking, see Deadlocks

Default

60 seconds.

Example

cloudscape.locks.deadlockTimeout=30

-- database-wide property
CALL PropertyInfo.setDatabaseProperty(
    'cloudscape.locks.deadlockTimeout', '30')

-- publishing a database-wide property
CREATE PUBLICATION APub
ADD TARGET DATABASE PROPERTY
cloudscape.locks.deadlockTimeout=
    '30'

Scope

database-wide (publishable)

system-wide

Dynamic or Static

Dynamic; the change takes effect immediately. For information about dynamic changes to properties, see Dynamic or Static Changes to Properties.