Procedure - 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ā„¢
  1. Copy the archive or class for the module that you will use on demand to a well known and uniform directory on each node.

    For example, suppose you copy the archive file myclasses.jar to /java/MyClasses on each node of a Linux system.

  2. Configure the JVM class path using the cufconfig utility to include the archive or class.
    1. Create a text file that contains the following text:

      -cp <path1>

      where <path1> is the path to the archive or class.

      For example, you can create a text file called jvmenv.txt in the /tmp directory that contains the following:

      -cp /java/MyClasses/myclasses.jar

    2. Set appropriate privileges for the text file:

      chmod 666 jvmenv.txt

    3. Create another text file that contains the following text:

      JavaEnvFile:<path2>

      where <path2> is the path to and name of the text file you created previously.

      For example, you can create a text file called cuf.txt that contains the following:

      JavaEnvFile:/tmp/jvmenv.txt

    4. Use the -f option of the cufconfig utility, specifying the name of the file you created in the preceding step. For example:

      cufconfig -f cuf.txt

  3. Use the -o option of the cufconfig utility to verify your changes.

    cufconfig -o

  4. Restart the database using the following command for the changes to take effect:

    tpareset -y

For details on cufconfig and tpareset, see Teradata Vantageā„¢ - Database Utilities, B035-1102.