17.00 - Configuring the Database Environment - Parallel Transporter

Teradata® Parallel Transporter Application Programming Interface Programmer Guide

prodname
Parallel Transporter
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-2516-220K

To call the Teradata PT from an XSP, configure the database environment to register the necessary Teradata PT libraries. Depending on the operating system that Vantage is running on, this may involve relocating specific Teradata PT libraries as well as setting runtime environment variables using the Cufconfig utility. For more information on using the Cufconfig utility, see Teradata Vantage™ - Database Utilities , B035-1102 .

Configuring the Database on Linux

Before using the CREATE PROCEDURE SQL statement to create a Teradata PT XSP, the following libraries from the Teradata PT package must be moved into the /usr/tdbms/lib directory:
  • libtelapi.so
  • libpxicu.so

If the default Teradata PT installation is used, these libraries can be found in the /opt/teradata/client/17.00/lib64 directory.

After using the CREATE PROCEDURE SQL statement to create a Teradata PT XSP, configure the database environment to allow the XSP to run. If it is possible to restart the database, use the Cufconfig utility to set the CLIEnvFile variable to register a file with the following environment variable settings:

COPERR=/usr/lib64
COPLIB=/usr/lib64

Add the location of the dynamic library containing the user created XSP to the LD_LIBRARY_PATH in the environment variable settings file. After setting the CLIEnvFile variable using the Cufconfig utility, the database must be restarted to allow the database to register the new runtime environment settings.

If it is not possible to restart the database, move the following Teradata PT libraries into the /usr/tdbms/lib directory:
  • libopcommon.so
  • libexportop.so (If using the Export driver)
  • libloadop.so (If using the Load driver)
  • libstreamop.so (If using the Stream driver)
  • libupdateop.so (If using the Update driver)

If the default Teradata PT installation is used, these libraries can be found in the following directory:

/opt/teradata/client/tbuild/17.00/lib64

Move the opermsgs.cat message catalog into the / (root) directory. If the default Teradata PT installation is used, find this catalog in the following directory:

/opt/teradata/client/tbuild/17.00/msg

Lastly, place the dynamic library containing the user created XSP in the /usr/tdbms/lib directory.