Database and library environment variables

Set database and library environment variables that are required for your databases (customer tables and system tables, if you chose Manual Database Setup during installation) and operating system. You can set the database and library variables in the setenv.sh file.

Following table describes database names with their syntax and descriptions.

Table 1. Database environment variables

This two-columned table describes database names in one column and their syntax with description in second column.

Database Syntax and Description

DB2®

DB2DIR=full_dir_path

export DB2DIR

DB2 installation directory (for example, /usr/lpp/db2_06_01)

. full_path_to_db2profile

Sources the database configuration for DB2 users (e.g./home/db2inst1/sqllib/db2profile).

Note the ". " (period and then a space).

Netezza®

NZ_ODBC_INI_PATH=full_dir_path

export NZ_ODBC_INI_PATH

Directory location of the odbci.ini file

(e.g. /opt/odbc64v51)

ODBCINI=full_path_and_file_name

export ODBCINI

Full path to the odbc.ini file

Oracle

ORACLE_BASE=full_dir_path

export ORACLE_BASE

Oracle installation directory

ORACLE_HOME=full_dir_path

export ORACLE_HOME

Oracle's home directory (e.g. /home/oracle/OraHome1).

Teradata

ODBCINI=full_path_and_file_name

export ODBCINI

Full path to the obdc.ini file

Define the library environment variable as mentioned in the following table, depending on your UNIX™ operating system.

Table 2. Library environment variable

This two-columned table describes operating systems in one column and library environment variable values in second column.
Operating System Value

SunOS and Linux™

LD_LIBRARY_PATH

For example:

LD_LIBRARY_PATH=<Campaign_Home>/bin:<path to DB lib directory>:$LD_LIBRARY_PATH

export LD_LIBRARY_PATH

Note: If LD_LIBRARY_PATH_64 (for 64-bit linking) is set, remove it. The LD_LIBRARY_PATH variable will be ignored if LD_LIBRARY_PATH_64 is set.

AIX®

LIBPATH

For example: LIBPATH=<Campaign_Home>/bin:<path to DB lib directory>:/usr/lib:$ORACLE_HOME/lib32:$ORACLE_HOME/lib

HP-UX

SHLIB_PATH

For example: SHLIB_PATH=<Campaign_Home>/bin:<path to DB lib directory>:/usr/lib:$ORACLE_HOME/lib32:$ORACLE_HOME/lib

Library directories for Oracle databases

Different versions of Oracle have different naming conventions for their lib directories. Older versions used lib for 32-bit and lib64 for 64-bit. Newer versions use lib32 for 32-bit and lib for 64-bit.

If you install 32-bit Campaign, you must include either $ORACLE_HOME/lib32 or $ORACLE_HOME/lib , whichever one contains the 32-bit Oracle libraries.

If you install 64-bit Campaign, you must include either $ORACLE_HOME/lib or $ORACLE_HOME/lib64, whichever one contains the 64-bit Oracle libraries.

Note: Do not include paths to both the 32- and 64-bit libraries; include only the path to the library you are using for your version of Campaign.