Configure the udfGPL Server Memory Limit | Teradata Vantage - Configuring the udfGPL Server Memory Limit - Analytics Database - Teradata Vantage

SQL External Routine Programming

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
iiv1628111441820.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1147
lifecycle
latest
Product Category
Teradata Vantageā„¢

As mentioned in the Installing the udfGPL Library, you can adjust the memory limit of the udfGPL server, within which ExecR operates.

Run the cufconfig GDO (Globally Distributed Object) utility and look for the GPLUDFServerMemSize field, if you wish to modify the default 32 MB memory limit of the udfGPL server. Recommended values for the GPLUDFServerMemSize field are in the range of 1 - 3 GB (1073741824 to 3221225472 bytes). Lack of memory might result in errors during ExecR execution.

The following example assumes default settings on a system, and shows how to check and change the GPLUDFServerMemSize value to 1 GB.

  1. Connect as root user to the target system, and use a Bash shell command line for the following.
  2. Inspect the current cufconfig parameters and their values by executing the command:/usr/tdbms/bin/cufconfig -o
  3. Locate the GPLUDFServerMemSize field in the output listing. It should appear among the output as follows:
    ...
       GPLUDFServerMemSize: 33554432
       ...
    This means the GPLUDFServerMemSize size is 33554432 bytes / 1024 (KB/byte) / 1024 (MB/KB) = 32 MB.
  4. To change this value to 1 GB, create a text file in the /tmp directory of every node on the server, so that this file contains the line: GPLUDFServerMemSize: 1073741824, using the following command:

    psh "printf 'GPLUDFServerMemSize: 1073741824' > /tmp/ccChange.txt"

    Memory size must be specified in bytes.
  5. Invoke the cufconfig utility to accept the new setting by executing the following command:

    psh /usr/tdbms/bin/cufconfig -i -f /tmp/ccChange.txt

  6. You can inspect the result of your action by typing again, using the following command:

    /usr/tdbms/bin/cufconfig -o

Changes in the GPLUDFServerMemSize field take effect the following time an ExecR query is executed.