Cloudscape Properties
Page 30 of 47

cloudscape.locks.waitTimeout

Function

Specifies the number of seconds after which Cloudscape aborts a transaction when it is waiting for a lock. When Cloudscape aborts (and rolls back) the transaction, the transaction receives an SQLException of SQLState 40XL1.

The time specified by this property is approximate.

A zero value for this property means that Cloudscape aborts a transaction any time it cannot immediately obtain a lock that it requests.

A negative value for this property is equivalent to an infinite wait time; the transaction waits forever to obtain the lock.

If this property is set to a value greater than or equal to zero but less than the value of cloudscape.locks.deadlockTimeout, then Cloudscape never performs any deadlock checking.

Default

180 seconds.

Example

CALL PropertyInfo.setDatabaseProperty(
    'cloudscape.locks.waitTimeout', '15')
cloudscape.locks.waitTimeout=60

-- publishing a database-wide property
ALTER PUBLICATION APub
ADD TARGET DATABASE PROPERTY
cloudscape.locks.waitTimeout=
    '15'

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.