Table of Contents

Search

  1. Installation Overview
  2. Before You Install the Services
  3. Service Installation
  4. After You Install the Services
  5. Client Installation
  6. Uninstallation
  7. Starting and Stopping Informatica Services
  8. Connecting to Databases from Windows
  9. Connecting to Databases from UNIX
  10. Updating the DynamicSections Parameter of a DB2 Database
  11. Installation and Configuration Checklist
  12. Split Domain Configuration for Metadata Manager

Installation and Configuration Guide

Installation and Configuration Guide

Configure Database Client Environment Variables on UNIX

Configure Database Client Environment Variables on UNIX

Configure database client environment variables on the machines that run the Data Integration Service, PowerCenter Integration Service, and PowerCenter Repository Service processes.
The database client path variable name and requirements depend on the UNIX platform and the database.
After you configure the database environment variables, you can test the connection to the database from the database client.
The following table lists the database environment variables you need to set in UNIX:
Database
Environment Variable Name
Database Utility
Value
Oracle
ORACLE_HOME
PATH
sqlplus
Set to: <
DatabasePath
>
Add: <
DatabasePath
>/bin
IBM DB2
DB2DIR
DB2INSTANCE
PATH
db2connect
Set to: <
DatabasePath
>
Set to: <
DB2InstanceName
>
Add: <
DatabasePath
>/bin
Sybase ASE
SYBASE15
SYBASE_ASE
SYBASE_OCS
PATH
isql
Set to: <
DatabasePath
>/sybase
<version>
Set to: ${SYBASE15}/ASE-
<version>
Set to: ${SYBASE15}/OCS-
<version>
Add: ${SYBASE_ASE}/bin:${SYBASE_OCS}/bin:$PATH