Warehouse Manager Installation Guide

Configuring the warehouse agent environment

This section describes the environment variables that you need to set in your IWH.environment file. All the environment variables that you must change are located between the START and END comment lines. Figure 2 displays the configurable portion of a sample IWH.environment file.

The following rules apply to both ODBC and DB2 CLI users:

1. You must set the DB2INSTANCE variable in all situations.
2. For DB2 CLI access, you need to set only the variables in the DB2 environment section.

   To access warehouse sources or targets in DB2 databases, you must configure the variables in the DB2 environment section.

3. You must remove the comment characters (#) for the variables that you set.

The following rules apply to ODBC users:

1. For ODBC access, you must set the IS_ODBC variable to the ODBC install path. This variable must not have comments.

   On AIX, the default path is /usr/lpp/db2_07_01/odbc. On the Solaris Operating Environment, the default path is /opt/IBMdb2/V7.1/odbc.

2. Set the ODBC environment variables for any databases that you selected.

When you change settings in the IWH.environment file, you must restart the warehouse agent daemon.

Figure 2. Sample IWH.environment file

# !!!!!!!!!!!!!!!!!!!!!!!!!! ATTENTION !!!!!!!!!!!!!!!!!!!!!!!!! # !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! # ! START OF MUST SET ENVIRONMENT VARIABLES SECTION ! # !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! # ! DB2 environment section. Please set DB2 instance id ! # DB2INSTANCE=<.... your DB2 instance id ....> LANG=en_US LC_ALL=en_US DB2CODEPAGE=819 export DB2INSTANCE LANG LC_ALL DB2CODEPAGE # ! If using Data Warehouse Center ODBC drivers, set the # ! IS_ODBC environment variable to the path for # ! Data Warehouse Center ODBC drivers directory. # # IS_ODBC=<....your ODBC base install directory> # Should have path for Data Warehouse Center ODBC drivers odbc dir # ! For essbase udp, set the following path : ! # # ARBORPATH=<..../essbase> # export ARBORPATH # ! If using Oracle ODBC driver, set the following paths: ! # # ORACLE_HOME=<.... your Oracle client HOME dir ....> # TNS_ADMIN=<.... your TNS_ADMIN dir ....> # ORACLE_SID=<.... your ORACLE_SID ....> # export ORACLE_HOME TNS_ADMIN ORACLE_SID # ! If using Sybase ODBC driver, set the following paths: ! # # SYBASE=<.... your Sybase client dir ....> # DSQUERY=<.... your DSQUERY value ....> # export SYBASE DSQUERY # ! If using Informix ODBC driver, set the following paths:! # # INFORMIXDIR=<.... your Informix client dir ....> # INFORMIXSERVER=<.... your Informix Server ....> # export INFORMIXDIR INFORMIXSERVER # Environment variables for JCL templates and logs. # You can choose to change values for following environment variables ! # VWSPATH=<... the warehouse agent base install directory ...> VWS_LOGGING=/var/IWH/ # default path export VWS_LOGGING VWSPATH # !!!!!!!!!!!!!!!!!!!!!!!!!! ATTENTION !!!!!!!!!!!!!!!!!!!!!!!!! # !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! # ! END OF MUST SET ENVIRONMENT VARIABLES SECTION ! # !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

To configure the warehouse agent environment:

1. Set the connection type:
   1. Log on as root.
   2. Change to the bin subdirectory in the install directory by entering one of the following commands:
      • On AIX, enter cd /usr/lpp/db2_07_01/bin
      • On the Solaris Operating Environment, enter cd /opt/IBMdb2/V7.1/bin
   3. Establish the correct soft link to IWH2AGNT. To do this, run the IWH.agent.db.interface command. The syntax for this command is:

      IWH.agent.db.interface [ odbc | db2cli ]
      

      The warehouse agent executable file has two versions:

      • The IWH2AGNT.db2cli file is the DB2 CLI link. Use this link to access DB2 family and heterogeneous data through DataJoiner (Oracle, Sybase, Microsoft SQL Server, Informix, VSAM, and IMS).

        This is the default link.

      • The IWH2AGNT.ivodbc file is the ODBC link. Use this link to access DB2 family, Oracle, Sybase, and Informix databases, and data files.
2. To access DB2 or DataJoiner source or target data, set the following variables in your IWH.environment file. On AIX, the file is located in the /usr/lpp/db2_07_01/bin directory. On the Solaris Operating Environment, the file is located in the /opt/IBMdb2/V7.1/bin directory. You need to set these variables whether you use a double-byte character set (DBCS) or a single-byte character set (SBCS).
   • DB2INSTANCE = the name of the DB2 instance on which you plan to run the warehouse agent

     If you have multiple DB2 instances, you must choose one instance to be the master DB instance.

   • LANG = your local locale
   • LC_ALL = your local locale

     The LANG and LC_ALL environment variables direct the warehouse agent to set the locale to your local locale.

   • DB2CODEPAGE = the code page of the client database

     The DB2CODEPAGE variable overrides the system code page. This variable is used to communicate with servers that cannot interpret the default code page from the client. The DB2CODEPAGE variable sets the default code page to a code page that the server supports. For more information, see the Installation and Configuration Supplement.

3. To access ODBC data using the Data Warehouse Center ODBC drivers, set the following variables in your IWH.environment file:
   • IS_ODBC = the base directory where you installed the Data Warehouse Center ODBC drivers
   • To access Oracle data, set the following environment variables:
     • ORACLE_HOME
     • TNS_ADMIN
     • ORACLE_SID
   • To access Sybase data, set the following environment variables:
     • SYBASE
     • DSQUERY
   • To access Informix data, set the following environment variables:
     • INFORMIXDIR
     • INFORMIXSERVER
4. To access Essbase or DB2 OLAP Server data, set the ARBORPATH environment variable in your IWH.environment file.
5. Optional: Customize your environment further by setting the following variables in your IWH.environment file:
   • VWS_LOGGING = the directory where the warehouse agent trace files, program output logs, and environment output files are stored.

     The default directory is /var/IWH.

   • VWSPATH = the warehouse agent base install directory.
   • ODBCINI = the default .odbc.ini file for ODBC users.
   • VWA_LOCALE_TABLE = locale conversion table.

     If you are using a national language version of the Solaris Operating Environment warehouse agent, you might need to choose a user-defined conversion table that the agent can use for string conversions. To do this, add the environment variable VWA_LOCALE_TABLE to the IWH.environment file and set its value to the code set that you want to use (for example, 8859-1 for en_US).

6. If you are using a shared /etc/services file in the NIS or AFS environment, add the following services to the shared /etc/services file.

   If these port numbers are already in use in your operating environment, you can change them in the /etc/services file on your system. However, you must also change the same port numbers on the workstation where the Data Warehouse Center administrative client and warehouse server are installed, and on all the associated warehouse agent sites.

   You must add these services because the install process updates only your local /etc/services file.

   Port Name

   Port Number

   vwd

   11001/tcp

   vwlogger

   11002/tcp

7. For these changes to take effect, stop and restart the warehouse agent daemon:
   1. Determine the daemon process ID by entering:

      ps -e | grep vwdaemon
      

   2. Stop the daemon by entering:

      kill pid
      

      where pid is the daemon process ID.

   After you stop the daemon, it will restart automatically.