DEADLOCK_TIMEOUT

onconfig.std
value

60

units

Seconds

range of values

Positive integers

takes effect

When shared memory is initialized

utilities

onutil

refer to

The chapter on distributed queries in the IBM Informix Guide to Database Design and Implementation.

DEADLOCK_TIMEOUT specifies the maximum number of seconds that a database server thread can wait to acquire a lock. This parameter is used only when performing a distributed query. Nondistributed queries do not use this parameter.

If a distributed query is forced to wait for a shared-memory resource longer than the number of seconds specified by this parameter, the thread that owns the transaction assumes that a multiserver deadlock exists. The following error message is returned:

-154 ISAM error: deadlock timeout expired - Possible deadlock

This parameter is also used in conjunction with the SET LOCK MODE statement to help avoid server deadlocks. For more information see the IBM Informix Guide to Database Design and Implementation. For more information on the SET LOCK MODE statement, see the IBM Informix Guide to SQL: Syntax.

To modify the DEADLOCK_TIMEOUT parameter dynamically, use the onutil SET command. Example:

% onutil
1> SET DEADLOCK_TIMEOUT 120;