All Forums Connectivity
EA230039 3 posts Joined 11/09
19 Sep 2013
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

veehell 19 posts Joined 07/12
20 Sep 2013

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-

EA230039 3 posts Joined 11/09
20 Sep 2013

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!

emilwu 72 posts Joined 12/07
24 Sep 2013

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
 

You must sign in to leave a comment.