Solving concurrent and dead lock problems at database level

Abstract

The main problem in having a program that runs on many computers and interacts with one database is to secure the execution of a query. The software used to solve these concurrent problems is DB2 (Database2), it is also distributed free and can be used by everyone. And for Java users there is an Eclipse plug-in called Data Studio. I have formulated 4 problems that could occur in SQL transactions and their solutions in DB2 by configuring the server and queries with specific options. I have also described how to solve the dead lock problem with some specific server configurations.