derby.locks.deadlockTrace

Function

Causes a detailed list of locks at the time of a deadlock or a timeout to be written to the error log (typically the derby.log). For a deadlock, Derby will describe the cycle of locks which caused the deadlock. For a timeout, Derby will print the entire lock list at the time of the timeout. This property is meaningful only if the derby.locks.monitor property is set to true.

Note: This level of debugging is intrusive: it can alter the timing of the application, reduce performance severely, and produce a large error log file. It should be used with care.

Default

False.

Example

-- system property
derby.locks.deadlockTrace=true

CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
    'derby.locks.deadlockTrace', 'true')

Dynamic or static

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