OLAP Setup and User's Guide

Updating the Environment Variables

On DB2 OLAP Starter Kit, you can set up an instance as an OLAP instance. When you set up an OLAP instance, the following environment variables are set for the OLAP Integration Server:
ISHOME = <DB2 instance directory>/sqllib/is
LIBPATH = $ISHOME/bin,$ISHOME/odbclib
PATH = $ARBORPATH/bin,$ISHOME/bin,$ISHOME/odbclib

On DB2 OLAP Server, the installation program does not update the .cshrc or .profile environment files. Because the format of these files varies depending on the shell you use, you need to manually update the appropriate file for your system.

Refer to the essbaseenv.doc file when setting environment variables. This file contains the shared library information that you need to add to your global environment.

Setting the ARBORPATH Variable

If you installed DB2 OLAP Server to /home/essbase, the essbaseenv.doc file contains this statement: ARBORPATH=/home/essbase

where home is the name of your home directory, and essbase is the name of the drive and directory where you installed DB2 OLAP Server.

Add this setting to your environment in the appropriate format for your system.

For example, in the C shell or Korn shell environment, you might add the following statement to your .cshrc environment file:

setenv ARBORPATH "/home/essbase"

In the Bourne shell environment, add this statement to your .profile environment:

ARBORPATH=/home/essbase; export ARBORPATH

Setting the Library Path Variable

Update your system's library path setting to include the $ARBORPATH/bin directory.

In AIX

In the C shell or Korn shell environment, you might add the following statement to your .cshrc environment file:

setenv LIBPATH "$LIBPATH:$ARBORPATH/bin"

In the Bourne shell environment, add this statement to your .profile environment:

LIBPATH=$LIBPATH:$ARBORPATH/bin; export LIBPATH

In Solaris Operating Environment

In the C shell or Korn shell environment, you might add the following statement to your .cshrc environment file:

setenv LD_LIBRARY_PATH "/usr/openwin/lib:/usr/lib:$ARBORPATH/bin:$ARBORPATH/dlls"

In the Bourne shell environment, add this statement to your .profile environment:

LD_LIBRARY_PATH=/usr/openwin/lib:/usr/lib:$ARBORPATH/bin:$ARBORPATH/dlls
export LD_LIBRARY_PATH
 

In HP-UX

In the C shell or Korn shell environment, you might add the following statement to your .cshrc environment file:

setenv SHLIB_PATH "$SHLIB_PATH:ARBORPATH/bin"

In the Bourne shell environment, add this statement to your .profile environment:

SHLIB_PATH=$SHLIB_PATH:$ARBORPATH/bin
export LIBPATH
 

Kernel Configuration Parameters

For HP-UX and Solaris Operating Environment, you might need to update the kernel configuration to a value of 64 or more. For example:

set shmsys:shminfo_shmseg=64 
set semsys:seminfo_semume=64

Refer to Quick Beginnings for DB2 Universal Database for UNIX for information about updating kernal configuration parameters.

Verifying the AIX Environment

The following tips help you verify that your AIX environment variables in the .profile file are set correctly to run DB2 OLAP Server:

INSTHOME

Set to the DB2 instance directory, such as /home/dbinst1.

DB2INSTANCEPATH

Set to $INSTHOME.

DB2INSTANCE

Set to the instance name DB2 OLAP Server is using, such as db2inst1.

LIBPATH

Include an entry for $ARBORPATH/dlls. Following this entry, include entries for $INSTHOME/sqllib/odbclib/lib and $INSTHOME/sqllib/lib.

Using the Set Path Command (Optional)

For convenience, you might want to issue a set path command so that you can quickly get to the DB2 OLAP Server directory.

For example, in the C shell or Korn shell environment:

set path=($path $ARBORPATH/bin)

In the Bourne shell environment:

PATH=$PATH:$ARBORPATH/bin; export PATH