GLOPLockWait - Teradata Vantage - Database Engine 20

Database Utilities

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Database Engine 20
Teradata Vantage
Release Number
20.00
Published
June 2025
ft:locale
en-US
ft:lastEdition
2026-03-26
dita:mapPath
ron1747160181474.ditamap
dita:ditavalPath
ft:empty
dita:id
vkz1472241255652
lifecycle
latest
Product Category
Teradata Vantageā„¢

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 Information

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