Teradata environment variables

There are required and optional environment variables for Teradata data sources. These variables are set in the db2dj.ini file.

The following environment variables are valid for Teradata:
  • COPLIB
  • COPERR
  • TERADATA_CHARSET (optional)
  • NETRACE (optional)
  • COPANOMLOG (optional)

Variable descriptions

COPLIB
Specifies the directory path on the federated server for the CLI system parameter block file clispb.dat. You must specify the fully qualified path for the COPLIB variable. The Teradata CLI installation directory of the clispb.dat file is /usr/lib, if you modify the directory path of the file, you must ensure that you update this variable: 
COPLIB=/usr/lib
For 64-bit clients, if you must run djxlinkTeradata.sh and the library is not located in the default location, then you must set the TERADATA_LIB_DIR environment variable to the directory location of the 64-bit client library. Depending on your operating system, the default locations for the library are:
  • AIX: /usr/lib/lib_64/libcliv2.so
  • Linux: /usr/lib64/libcliv2.so

Both the clispb.dat and error message catalog errmsg.cat files typically reside in the same directory.

COPERR
Specifies the directory path on the federated server for the errmsg.cat file. Specify the fully qualified path for the COPERR variable.
For example:
COPERR=/usr/lib
TERADATA_CHARSET
Specifies the code page character set to use with Teradata data sources.

Each time that the federated server connects to a Teradata data source, the Teradata wrapper determines which code page character set to use for that connection. You can have the Teradata wrapper set the code page character set or you can designate a code page by setting the TERADATA_CHARSET environment variable.

If the TERADATA_CHARSET environment variable is set in the db2dj.ini file on the federated server, the wrapper uses the code page character set in the db2dj.ini file. The value in the TERADATA_CHARSET environment variable is not validated, but if the environment variable is not set to a valid value, the Teradata data source returns an error.

If the TERADATA_CHARSET environment variable is not set in the db2dj.ini file on the federated server, the wrapper detects the client character set based on the code page of the database.

On federated servers that run UNIX, the following values are valid for the TERADATA_CHARSET environment variable:
  • HANGULKSC5601_2R4
  • KanjiEUC_0U
  • LATIN1_0A
  • LATIN9_0A
  • LATIN1252_0A
  • SCHGB2312_1T0
  • TCHBIG5_1R0
  • UTF8
  • ASCII
On federated servers that run Windows, the following values are valid for the TERADATA_CHARSET environment variable:
  • HANGULKSC5601_2R4
  • KanjiSJIS_0S
  • LATIN1_0A
  • LATIN1252_0A
  • SCHGB2312_1T0
  • TCHBIG5_1R0
  • UTF8
  • ASCII
NETRACE
Optional. Enables the tracing feature of the Teradata client software. This variable is needed only for debugging.
COPANOMLOG
Optional. Enables the logging feature of the Teradata client software. This variable is needed only for debugging.