Configuring the UNIX Environment for Data Access

For the data access technology to work on UNIX systems, the server software’s startup script must be configured.

Open the Startup Script

  1. Change to the /bin subdirectory in the server software’s installation directory. For example, at the UNIX prompt type:

    cd /usr/local/serverproduct/bin

    where /usr/local/serverproduct/bin is the /bin subdirectory of the directory in which the server software is installed.

  2. Open statsenv.sh with a text editor.

Specify the DataDirect Script

  1. Search for the first comment that contains the text:

    MERANT_ENVIRONMENT_SCRIPT

  2. Find the line that defines the location of odbc.sh.
  3. Edit the line so it contains the correct path to your Connect ODBC client installation, and remove the comment character if it has one. For example, change:

# MERANT_ENVIRONMENT_SCRIPT=/usr/slodbc50/5_01_00/odbc.sh

to:

MERANT_ENVIRONMENT_SCRIPT=/usr/myDataAccess/slodbc50/5_01_00/odbc.sh

Add odbc.ini Environment Variable

  1. Add the following lines after the lines above to create an environment variable, ODBCINI, that allows IBM® SPSS® Statistics Server to find the odbc.ini file:
ODBCINI=ODBCDIR/odbc.ini
export ODBCINI

where ODBCDIR is replaced by the path to your Connect ODBC installation directory.

Add Paths to Database Libraries

  1. Add lines appropriate for your database, usually the database home directory and, if you are not using the Data Direct Wire Protocol drivers, a path to the database libraries. For example, if you are using Oracle on Linux, add the following lines:
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/bigdisk/oracle/product/8.1.6/lib
export LD_LIBRARY_PATH
ORACLE_HOME=/bigdisk/oracle/product/8.1.6
export ORACLE_HOME

where /bigdisk/oracle/product/8.1.6 is replaced by the path to your Oracle installation directory and LD_LIBRARY_PATH is the library path variable for your operating system.

Note that the Data Direct Wire Protocol drivers do not require the installation of database client libraries. However, other Data Direct drivers require these libraries.

Save the Startup Script

  1. Save statsenv.sh.

Edit odbc.ini

  1. Edit odbc.ini, the ODBC configuration file, so that ODBC data sources can be accessed from IBM SPSS Statistics Server. See the appendix "The UNIX Environment" in DataDirect's DataDirect Connect ODBC Reference (available if you installed the additional DataDirect documentation when you installed Connect ODBC) and the chapters for specific drivers in odbchelp.pdf in the doc subdirectory of your Connect ODBC installation directory.

The change will take effect the next time you start the server software.

Note: If you plan to use ODBC with the IBM SPSS Statistics Batch Facility, you need to modify the IBM SPSS Statistics Batch Facility startup script in the same manner.