HP 3000 Manuals HP 3000 Manuals
IMAGE/SQL Deadlocks A deadlock occurs when two or more transactions are in a simultaneous wait state and each needs data that is held and locked by the other. When a deadlock is encountered, the TurboIMAGE/XL intrinsic DBLOCK returns an error to IMAGE/SQL. IMAGE/SQL then aborts the IMAGE/SQL transaction that caused the deadlock. Transaction priorities are not considered in determining which transaction is aborted--the IMAGE/SQL transaction that caused the deadlock is aborted.[REV BEG] To avoid a deadlock situation during a connection, set the MAXIMUM TIMEOUT and DEFAULT TIMEOUT. You can set the DEFAULT and MAXIMUM TIMEOUT during the START DBE NEW or change the value using SQLUtil. If you do not set the timeout value, the default is unlimited time. [REV END]