derby.locks.deadlockTrace The derby.locks.deadlockTrace property causes a detailed list of locks at the time of a deadlock or a timeout to be written to the error log (typically the file derby.log). derby.locks.deadlockTrace property Deadlockstracing

For a deadlock, describes the cycle of locks which caused the deadlock. For a timeout, prints 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 .