derby.locks.deadlockTrace derby.locks.deadlockTraceDeadlockstracing
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, will describe the cycle of locks which caused the deadlock. For a timeout, 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. 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 .