16.10 - GLOPLockWait - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Purpose

Specifies the maximum time, in seconds, that an external routine can hold a lock on global and persistent (GLOP) data if another external routine is waiting for the lock to be freed. When the lock exceeds the GLOPLockWait value, the transaction that was holding the lock is aborted, and the lock is freed.

GLOP data is a type of data available to external routines. The persistence in memory of GLOP data is based on specific boundaries, such as a user role or user account.

Valid Range

0 to 2147483647 (the maximum size of an SQL INTEGER data type)

Default

120 seconds

Usage Notes

This should be a value slightly less than the value for GLOPLockTimeout value.

Related Topics

For more information on global and persistent data, see SQL External Routine Programming.