Informatica 9.1.0 64 bit AIX and TPT 14

Connectivity
Teradata Employee

Informatica 9.1.0 64 bit AIX and TPT 14

Hi,

I'm having trouble with the configuration of TPT 14 on an AIX 64 bit server and Informatica 9.1.0 64 bit.

I've configured the ODBC 64 bit connection and the standalone utilities (bteq, fastload, etc.) with informatica and works fine. But I can't make TPT to work. I know that TPT is a 32 bit application, so most of the times I get the classic "invalid magic number" when Informatica tries to call TPT.

I've figure out that the problem is in the LIBPATH variable:

 - If I use export LIBPATH=/opt/teradata/client/14.00/tbuild/lib:/opt/teradata/client/14.00/odbc_64/lib:/usr/teragss/aix-power:/usr/bin

     The ODBC works, but TPT won't

 - If I usr export LIBPATH=/opt/teradata/client/14.00/tbuild/lib:/usr/teragss/aix-power.32:/opt/teradata/client/14.00/odbc_64/lib

      The standalone utilities and TPT works, but not the ODBC

How can I make all work?

Thx

3 REPLIES
Teradata Employee

Re: Informatica 9.1.0 64 bit AIX and TPT 14

I think you kind of mix PATH(for binaries) and LD_LIBRARY_PATH/LIBPATH(for libraries). Also to get working ODBC on AIX you probably need to define $ODBCINI variable, pointing to correct one. Informatica supply their own ODBC, but you might have some AIX default ones.

Without env list, log entry ... and so on, it is hard to find what is/what might be wrongly configured.

Cheers
-=[VH]=-
Teradata Employee

Re: Informatica 9.1.0 64 bit AIX and TPT 14

Hi Veehell,

I've added the TD directories to the .profile file of the user running Informatica service, and I've found out that when the service is starting adds new directories in front of LIBPATH

The Informatica error is (I've used the 32 bits ODBC libraries to try to make TPT work):

Message: Couldn't load the library [libpmtptwriter.a] for plug-in #315000.  Error msg: [Database driver event...Error occurred loading library [Could not load module /Informatica/9.1.0/server/bin/libodbc.a(odbc.so).

    Dependent module /opt/teradata/client/14.00/odbc_32/lib/libodbcinst.a(odbcinst.so) could not be loaded.

    The module has an invalid magic number.

Could not load module /Informatica/9.1.0/server/bin/libpmtptwriter.a.

    Dependent module /Informatica/9.1.0/server/bin/libodbc.a(odbc.so) could not be loaded.]Database driver event...Error occurred loading library [libpmtptwriter.a]].

And the variables that are running are: 

AIXTHREAD_SCOPE=S

AUTHSTATE=compat

CLASSPATH=:/Informatica/9.1.0/tomcat/bin/bootstrap.jar:/Informatica/9.1.0/java/lib/tools.jar

CLCMD_PASSTHRU=1

CMJAVA_PATH=/Informatica/9.1.0/java/jre/lib/ppc64/j9vm:/Informatica/9.1.0/java/jre/lib/ppc64

COPERR=/opt/teradata/client/14.00/lib

COPLIB=/opt/teradata/client/14.00/lib

CORE_MMAP=yes

ERRNO=25

FCEDIT=/usr/bin/ed

HOME=/home/pwcenter

IBM_JAVA_COMMAND_LINE='/Informatica/9.1.0/java/bin/java -ea -Djava.awt.headless=true -Duser.dir=/Informatica/9.1.0/tomcat/bin -DINFA_HOME=/Informatica/9.1.0 -DINFA_DOMAINS_FILE=/Informatica/9.1.0/domains.infa -Djava.endorsed.dirs=/Informatica/9.1.0/tomcat/common/endorsed -classpath :/Informatica/9.1.0/tomcat/bin/bootstrap.jar:/Informatica/9.1.0/java/lib/tools.jar -Dcatalina.base=/Informatica/9.1.0/tomcat -Dcatalina.home=/Informatica/9.1.0/tomcat -Djava.io.tmpdir=/Informatica/9.1.0/tomcat/temp -Djava.util.logging.config.file=/Informatica/9.1.0/tomcat/bin/isplogging.properties -Xmx512m -Xmx1024m -XX:GCTimeRatio=9 -XX:MaxPermSize=128m -Xdump:java:events=uncaught,filter=*OutOfMemoryError* -Djava.nio.channels.spi.SelectorProvider=sun.nio.ch.PollSelectorProvider -Dssl.KeyManagerFactory.algorithm=IbmX509 -Dssl.TrustManagerFactory.algorithm=IbmX509 org.apache.catalina.startup.Bootstrap start'

IBM_JVM_AIXTHREAD_SCOPE_NEW_VALUE=S

IBM_JVM_CHANGED_ENVVARS_5767302=AIXTHREAD_SCOPE,NULLPTR,CORE_MMAP

IBM_JVM_CORE_MMAP_NEW_VALUE=yes

IBM_JVM_NULLPTR_NEW_VALUE=NOSEGV

IFCONTENTMASTER_HOME=/Informatica/9.1.0/DataTransformation/

IFS='  

'

INFA_DOMAINS_FILE=/Informatica/9.1.0/domains.infa

INFA_HOME=/Informatica/9.1.0

INFA_JAVA_OPTS='-Xmx512m -Xmx1024m -XX:GCTimeRatio=9 -XX:MaxPermSize=128m -Xdump:java:events=uncaught,filter=*OutOfMemoryError* -d64 -Djava.nio.channels.spi.SelectorProvider=sun.nio.ch.PollSelectorProvider -Dssl.KeyManagerFactory.algorithm=IbmX509 -Dssl.TrustManagerFactory.algorithm=IbmX509'

INFA_NODE_NAME=node01_pwapdesa

JAVA_HOME=/Informatica/9.1.0/java

LANG=en_US

LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P1

LC_ALL=C

LC__FASTMSG=true

LDR_CNTRL=USERREGS

LD_LIBRARY_PATH=/Informatica/9.1.0/ODBC6.1/lib:/Informatica/9.1.0/ODBC6.1:/Informatica/9.1.0/ODBC6.1/bin:/Informatica/pwcenter/app/pwcenter/product/11.2.0/lib:/usr/dt/lib:/usr/openwin/lib:/usr/lib:/Informatica/9.1.0/server/bin:/opt/teradata/client/14.00/bin

LIBPATH=/Informatica/9.1.0/java/jre/lib/ppc64/j9vm:/Informatica/9.1.0/java/jre/lib/ppc64:/Informatica/9.1.0/java/jre/../lib/ppc64:/Informatica/9.1.0/server/bin:/Informatica/9.1.0/java/jre/bin/classic:/Informatica/9.1.0/java/jre/lib/ppc64:/Informatica/9.1.0/java/jre/bin:/opt/teradata/client/14.00/tbuild/lib64:/opt/teradata/client/14.00/odbc_32/lib:/usr/teragss/aix-power.32/client/lib:/usr/lib:/Informatica/9.1.0/ODBC6.1/lib:/Informatica/9.1.0/ODBC6.1:/Informatica/9.1.0/ODBC6.1/bin:/Informatica/pwcenter/app/pwcenter/product/11.2.0/lib:/usr/dt/lib:/usr/openwin/lib:/usr/lib:/Informatica/9.1.0/server/bin:/opt/teradata/client/14.00/bin:/Informatica/9.1.0/DataTransformation//bin:/Informatica/9.1.0/java/jre/lib/ppc64/j9vm:/Informatica/9.1.0/java/jre/lib/ppc64:/usr/lib

LINENO=1

LOCPATH=/usr/lib/nls/loc

LOGIN=pwcenter

LOGNAME=pwcenter

MAIL=/usr/spool/mail/pwcenter

MAILCHECK=600

MAILMSG='[YOU HAVE NEW MAIL]'

MANPATH=/usr/share/man:/opt/teradata/client/14.00/odbc_64/help/man:/usr/share/man:/opt/teradata/client/14.00/odbc_32/help/man:

NLSPATH=/opt/teradata/client/14.00/tbuild/msg64/%N:/opt/teradata/client/14.00/odbc_32/msg/%N:/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat

NLS_LANG=American_America.WE8ISO8859P1

NULLPTR=NOSEGV

ODBCHOME=/Informatica/9.1.0/ODBC6.1

ODBCINI=/Informatica/9.1.0/ODBC6.1/odbc.ini

ODMDIR=/etc/objrepos

OPTIND=1

ORACLE_BASE=/Informatica/pwcenter/app/pwcenter

ORACLE_HOME=/Informatica/pwcenter/app/pwcenter/product/11.2.0

OSSINFO=/Informatica/9.1.0/DataTransformation

PATH=/Informatica/9.1.0/server/bin:/Informatica/9.1.0/DataTransformation//bin:/opt/teradata/client/14.00/tbuild/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/pwcenter/bin:/usr/bin/X11:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/usr/ccs/bin:/Informatica/pwcenter/app/pwcenter/product/11.2.0/bin:/Informatica/9.1.0/server/bin

PMBUILD_PLATFORM=aix64

PPID=7471170

PS2='> '

PS3='#? '

PS4='+ '

PWD=/Informatica/9.1.0/server/bin

RANDOM=24416

SECONDS=0

SHELL=/usr/bin/ksh

SHLVL=1

SSH_CLIENT='192.168.168.146 52455 22'

SSH_CONNECTION='192.168.168.146 52455 192.168.7.16 22'

SSH_TTY=/dev/pts/5

TD_HOME=/opt/teradata/client/14.00

TD_ICU_DATA=/opt/teradata/client/14.00/tdicu/lib64

TERM=xterm

TMOUT=0

TPT_HOME=/opt/teradata/client/14.00/tbuild

TWB_ROOT=/opt/teradata/client/14.00/tbuild

TZ=America/Argentina/Buenos_Aires

USER=pwcenter

_=/Informatica/9.1.0/java/bin/java

Thanks!

Enthusiast

Re: Informatica 9.1.0 64 bit AIX and TPT 14

the simpler solution is to build a shell script called tbuild and put it in /usr/bin

basically the tbuild shell script will do the following:

1. set the library path 

2. pass the #@ to the real tbuild