Skip to main content
Previous sectionNext section

LockTimeout

Set the SQL lock timeout.

Synopsis

[SQL]    LockTimeout=n

n is an integer in the range 0—32,767. The default value is 10.

Description

LockTimeout is the lock timeout (in seconds) for InterSystems IRIS® data platform locks made during execution of SQL statements. The maximum value is 32,767 seconds, or 9 hours.

For further details, refer to the SET OPTION command.

Changing This Parameter

On the SQL page of the Management Portal (System Administration > Configuration > SQL and Object Settings > SQL), for the Lock Timeout (seconds) setting, enter a number.

To set the desired value for LockTimeout from the InterSystems Terminal, use the SetLockTimeout() method of the %SYSTEM.SQL class. See the class reference for details.

You can also change LockTimeout with the Config.SQL class (as described in the class reference) or by editing the CPF in a text editor (as described in the Editing the Active CPF section of the “Introduction to the Configuration Parameter File” chapter in this book).