GLOPLockTimeout - Analytics Database - Teradata Vantage

Database Utilities

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-05-02
dita:mapPath
ymn1628096214445.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
vkz1472241255652
lifecycle
latest
Product Category
Teradata Vantage™

Specifies the maximum time, in seconds, that an external routine (UDF, UDM, or external stored procedure) will wait for a lock request to be granted on global and persistent (GLOP) data.

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

130 seconds

Usage Notes

This should be a value slightly greater than the GLOPLockWait value.

When an external routine requests a lock on GLOP data, and the timeout value specified by GLOPLockTimeout is exceeded, the system returns a -2 error code to the external routine.

Related Information

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