Table of Contents

  1. Preface
  2. Upgrade Overview
  3. Before You Upgrade the Domain on Windows
  4. Before You Upgrade the Domain on UNIX
  5. Prepare for the Upgrade
  6. Upgrade the Domain
  7. Upgrade the Domain with Changes to Node Configuration
  8. Before You Upgrade the Application Services
  9. Application Service Upgrade
  10. Informatica Client Upgrade
  11. After You Upgrade
  12. Updating the DynamicSections Parameter of a DB2 Database
  13. Upgrade Checklist

Upgrading from Version 10.0

Upgrading from Version 10.0

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


Updated May 14, 2019


Explore Informatica Network