DataStage 8.5 support for Teradata 13

[jdenyer]

Just a quick note to let people know that as of the time of writing, DataStage 8.5 supports Teradata using 13.0 client tools on AIX 6.1. Teradata 13.1 is not working and a case has been submitted with support.

Additionally, it might help to realize that on AIX, DataStage 8.5 installs as a 64-bit application and you will need to intalll the Teradata 64-bit libraries.

I have enclosed some details on the LIBPATH showing the references to the Teradata libraries:

TWB_ROOT=/opt/teradata/client/13.0/tbuild
TD_SECURITY=/usr/teragss/aix-power/13.00.01.01; export TD_SECURITY
PATH=${TD_SECURITY}/bin:"${PATH}"; export PATH
ODBCINST=/opt/teradata/client/odbc/odbcinst.ini; export ODBCINST

# Add ASB libraries
LIBPATH=$ASBHOME/apps/jre/lib/ppc64:$ASBHOME/apps/jre/lib/ppc64/j9vm:$ASBHOME/lib/cpp:$ASBHOME/app
s/proxy/cpp/aix-all-ppc_64:$LIBPATH

# Add core DataStage libraries
LIBPATH=`dirname $DSHOME`/branded_odbc/lib:`dirname $DSHOME`/DSComponents/lib:`dirname $DSHOME`/DS
Components/bin:$DSHOME/lib:$DSHOME/uvdlls:`dirname $DSHOME`/PXEngine/lib:$LIBPATH

# Add TPT libraries
LIBPATH=$TD_ICU_DATA:`dirname $TD_ICU_DATA`/lib:$LIBPATH

# Add TPT and Other Teradata libraies
LIBPATH=$TWB_ROOT/lib64:$TWB_ROOT/lib:`dirname $TWB_ROOT`/lib64:`dirname $TWB_ROOT`/lib:$LIBPATH

# Add Teradata Security libraries
LIBPATH=$TD_SECURITY/lib:$LIBPATH

# Add Teradata ODBC libraries
LIBPATH=/opt/teradata/client/ODBC_64/lib:$LIBPATH
export LIBPATH