PowerCenter
- PowerCenter 10.5.3
- All Products
PGSERVICE: Set to the location of the pg_service.conf file: <pg_service.conf file directory>/pg_service.conf PGHOME: Set to PostgreSQL client install location. For example, /usr/pgsql -10 Add to PATH: $PGHOME/bin:${PATH} Add to LD_LIBRARY_PATH: $PGHOME/lib:${LD_LIBRARY_PATH}
ORACLE_HOME: Set to Oracle client install location. For example, /u01/app/oracle/product/19.0.0.0 Add to PATH: $ORACLE_HOME/bin:${PATH} Add to LD_LIBRARY_PATH: $ORACLE_HOME/lib:${LD_LIBRARY_PATH} Add TNS_ADMIN. The TNS entries are in the oratns folder. For example, /misc/platqa/ISPAutomation/oratns
DB2DIR: Set to DB2 client install location. For example, /opt/ibm/db2/V11.1 DB2INSTANCE: Instance name of the DB2 client. Add to PATH: $DB2DIR/bin:${PATH} Add to LD_LIBRARY_PATH: $DB2DIR/lib:${LD_LIBRARY_PATH} OR $DB2DIR/lib64:${LD_LIBRARY_PATH}
ODBCHOME=$INFA_HOME/ODBC<version> ODBCINI=$INFA_HOME/ODBC<version>/odbc.ini ODBCINST=$INFA_HOME/ODBC<version>/odbcinst.ini