A deadlock occurs when Process1 has a lock on ResourceA and wants to access ResourceB - and at the same time Process2 has a lock on ResourceB and wants to access ResourceA. Without looking at the exact code and nature of your application I cannot say for certain if your scenario could cause a deadlock, but my guess is that it might.

To minimize deadlocks code your applications such that they access data in the same order - and hence would not encounter deadlocks (but might encounter lock timeouts instead).

For More Information

• Dozens more answers to tough DB2 questions from Craig Mullins are available.
• The Best IBM DB2 Web Links: tips, tutorials, scripts, and more.
• Have a DB2 tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
• Ask your technical DB2 questions -- or help out your peers by answering them -- in our live discussion forums.
• Ask the Experts yourself: Our SQL, database design, SQL Server, DB2, Sybase, object-oriented and data warehousing gurus are waiting to answer your toughest questions.

• DB2 > DB2 with Craig Mullins

• Operating Systems
• IT Management
• Networking
• Database
• Security
• Servers and Storage
• Applications and Development
• Career Center

		Expert Answer Center: Expert Q&As