Configure DataDirect ODBC on UNIX with PowerCenter

Do the following to install DataDirect ODBC drivers on UNIX: Install the Informatica Services which include the DataDirect ODBC drivers for UNIX. Set the ODBCHOME environment variable  > ODBCHOME=/opt/Informatica/9.6.1/ODBC7.1; export ODBCHOME Add the $ODBCHOME/bin directory to the PATH environment variable: Using a Bourne shell: $ PATH=${PATH}:$ODBCHOME/bin; export PATH Using a C shell: $ setenv PATH ${PATH}:$ODBCHOME/bin  Add the $ODBCHOME/lib to the library path variable. (OPTIONAL) Copy the odbc.ini file to the location where you would like this file to be used. Typically the Informatica home directory is used. cp $ODBCHOME/odbc.ini $HOME/.odbc.ini Set the ODBCINI environment variable to the location of the .odbc.ini (or odbc.ini) file:  $ ODBCINI=$HOME/.odbc.ini; export ODBCINI OR $ ODBCINI=$ODBCHOME/odbc.ini; export ODBCINI Edit the odbc.ini file (specified by the $ODBCINI environment variable) as follows: Set the InstallDir to the ODBC installation directory ($ODBCHOME). Re-Start the Informatica Node services.

Informatica Power centre “Java Heap Size” memory error issue

Error:

The following out of memory condition (found in the catalina.out) is an indication that the Java heap size needs to be increased:

Exception class: Exception class: java.lang.OutOfMemoryError
java.lang.OutOfMemoryError
Caught an exception in one of the PCSF or PCSF base servlet threads. See below for the brief stack trace

Fix:

1. Login to the server with the user which is used for Informatica server.

2. Goto $INFA_HOME/tomcat/bin

3. Take backup of the file infaservice.sh

4. Change the below value Xmx512m to Xmx1024m or whatever the required number for variable INFA_JAVA_OPTS

"INFA_JAVA_OPTS="${INFA_JAVA_OPTS} -Xmx1024m"

While previously it was :

"INFA_JAVA_OPTS="${INFA_JAVA_OPTS} -Xmx512m".

Re-start the Node services.