How to Configure Deadlock Detection and Lock Wai

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How to Configure Deadlock Detection and Lock Wait Timeouts

ou configure the amount of time a transaction waits before Derby does any deadlock checking with the derby.locks.deadlockTimeout property. You configure the amount of time a transaction waits before timing out with the derby.locks.waitTimeout property. When configuring your database or system, you should consider these properties together. For example, in order for any deadlock checking to occur, the derby.locks.deadlockTimeout property must be set to a value lower than the derby.locks.waitTimeout property. If it is set to a value equal to or higher than the derby.locks.waitTimeout, the transaction times out before Derby does any deadlock checking.

By default, derby.locks.waitTimeout is set to 60 seconds. -1 is the equivalent of no wait timeout. This means that transactions never time out, although Derby can choose a transaction as a deadlock victim.

(Continued on next question...)

Other Job Interview Questions

• What is LDAP Directory Service
• Database-Side JDBC Procedures Using Non-Nested Connections
• How to Transfer Read-Only Databases to Archive (Jar or Zip) Files?
• How to Create the Boot Password?
• When Path Is Ambiguous with Databases in File System?
• What is Isolation Levels and Concurrency ?
• Explain about Conventions for Specifying the Database Path?
• JNDI-Specific Properties for External Directory Services
• Threads Sharing a Statement: A Case Study
• Standard Connections--Connecting to Databases in the File System Within the System
• More...