Configuring Database Client Driver Environment Variables on UNIX

Set up the database client driver environment variables before executing configure.sh.

Prerequisites

See Sybase IQ InfoPrimer Installation Guide > Planning Your Installation > System Requirements > Sybase IQ InfoPrimer Server > Interfaces > Interfaces Driver Versions
See the installation document published by each database client vendor for instructions in installing the database client.

Task

Set ODBCINI to the ODBC configuration file .odbc.ini.

# Set the Common ODBC environment.
setenv ODBCINI /path/to/.odbc.ini

Set ORACLE_HOME and TNS_ADMIN to the installed database instance client driver path.

# Set the Oracle Instant Client environment
	setenv ORACLE_HOME /path/to/oracle/home
	setenv TNS_ADMIN /path/to/oracle/home

If you are using DB2, execute db2cshrc script before using its drivers.

# Set the DB2 client environment
source /path/to/db2_client/home/nedb2i7/sqllib/db2cshrc

Set LD_LIBRARY_PATH to the database driver library files path.
```
# Set the LD_LIBRARY_PATH variable is reset to add the Oracle OCI
setenv LD_LIBRARY_PATH.
setenv LD_LIBRARY_PATH /path/to/oracle/home/libfolder/:$LD_LIBRARY_PATH
setenv LD_LIBRARY_PATH 
/path/to/IQ153C:/path/to/IQ153C/IQ-15_3:/path/to/IQ153C/IQ-15_3/lib64:$LD_LIBRARY_PATH
```
Note:
- On AIX platforms, use the environment variable LIBPATH instead of LD_LIBRARY_PATH.
- The environment variables setting for HP and Linux platforms is the same as the Solaris platform.
- On Windows platform, you do not need to set up the environment variables for the database client except for ORACLE_HOME.
Modify the configure.sh file.

Note: Remove the comment for the Open Client environment settings to use the embedded Open Client in IQ InfoPrimer.
Place the Open Client interfaces file in $SYBASE.
Execute configure.sh.
This generates the GridNode.sh needed to execute the IQ InfoPrimer gridnode server.