HPlogo IMAGE/SQL Administration Guide: HP 3000 MPE/iX Computer Systems > Chapter 5 IMAGE/SQL Locking

IMAGE/SQL Deadlocks

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Glossary

 » Index

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.

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.

Feedback to webmaster