17.10 - MallocLimit - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

Specifies the upper limit (in bytes) on the amount of memory that an external routine (UDF, UDM, or external stored procedure) can allocate using the Teradata C library function FNC_malloc.

Valid Range

0 to 18446744073709551615 bytes (hex FFFF FFFF FFFF FFFF)

Default

33554432 bytes (32MB)

Usage Notes

For performance reasons, a function should allocate only as much memory as absolutely required. UDFs execute in parallel on the database. An all-AMP query that includes a UDF which allocates 10MB of memory can use up to 1GB for all instances on a 100 AMP system for just the one transaction.

Related Information

For more information on the Teradata C-library functions, see Teradata Vantage™ - SQL External Routine Programming, B035-1147.