A deadlock occurs when two or more users mutually prevent each other from proceeding by the SQL locks that they have set.
Concepts of the Database System, SQL Locks
Database Parameters DeadlockDetectionLevel, DeadlockDumpFileName, Database Parameter
System Tables, DETECTEDDEADLOCKS