Teradata ODBC installation

Teradata installation:

copy the following tars on the server
tdodbc__aix_power32.12.00.00.01.tar
tdodbc__aix_power32.12.00.00.01.txt

untar them in /opt/odbc_teradata
you will see these files:

TeraGSS.12.00.00.00.tar.gz
tdicu.12.00.00.00.tar.gz
tdodbc__aix_power32.12.00.00.01.tar.gz
TeraGSS.12.00.00.00.txt
tdicu.12.00.00.00.txt
tdodbc__aix_power32.12.00.00.01.txt


# gunzip TeraGSS.12.00.00.00.tar.gz
# gunzip tdicu.12.00.00.00.tar.gz
# gunzip tdodbc__aix_power32.12.00.00.01.tar.gz


tar xvf TeraGSS.12.00.00.00.tar
tar xvf tdicu.12.00.00.00.tar
tar xvf tdodbc__aix_power32.12.00.00.01.tar


It should create these following directories

TeraGSS
tdicu
tdodbc

cd TeraGSS
installp -acXd TeraGSS_aix-power32_12.00.00.00.bff all

cd tdicu
installp -acXd tdicu.bff all

cd tdodbc
installp -acXd tdodbc.bff all


copy the following tars on the server
cliv2_AIX_POWER.12.00.00.02.tar.gz

untar them in /opt/odbc_teradata

you will the following directories:

power32
power32/TeraGSS
power32/TeraGSS/.toc, 651 bytes, 2 media blocks.
power32/TeraGSS/TeraGSS_aix-power32_12.00.00.04.bff, 122112000 bytes, 238500 media blocks.
power32/TeraGSS__aix_power32.12.00.00.04.txt, 737 bytes, 2 media blocks.

power64
power64/TeraGSS
power64/TeraGSS/.toc, 616 bytes, 2 media blocks.
power64/TeraGSS/TeraGSS_aix-power_12.00.00.04.bff, 128870400 bytes, 251700 media blocks.
power64/TeraGSS__aix_power64.12.00.00.04.txt, 737 bytes, 2 media blocks.

tdicu
tdicu/tdicu.bff, 23091200 bytes, 45100 media blocks.
tdicu/.toc, 232 bytes, 1 media blocks.
tdicu.12.00.00.00.txt, 1409 bytes, 3 media blocks.

cliv2
cliv2/cliv2.bff, 1331200 bytes, 2600 media blocks.
cliv2/.toc, 207 bytes, 1 media blocks.
cliv2__aix_power.12.00.00.02.txt, 2331 bytes, 5 media blocks.

cd cliv2
installp -acXd cliv2.bff all


==========================================

int installation
untar
goto /opt/odbc_teradata/power32/TeraGSS

installp -acXd TeraGSS_aix-power32_12.00.00.04.bff all
TeraGSS_aix-power32.TeraGSS 12.0.0.4 USR APPLY SUCCESS

goto /opt/odbc_teradata/tdicu
installp -acXd tdicu.bff all
tdicu.tdicu 12.0.0.0 USR APPLY SUCCESS
tdicu.tdicu 12.0.0.0 ROOT APPLY SUCCESS

goto /opt/odbc_teradata/cliv2
installp -acXd cliv2.bff all
cliv2.cliv2 12.0.0.0 USR APPLY SUCCESS
cliv2.cliv2 12.0.0.0 ROOT APPLY SUCCESS

untar tdodbc__aix_power32.12.00.00.01.tar
goto /opt/odbc_teradata/tdodbc
cd tdodbc
installp -acXd tdodbc.bff all

======================================



---------------------------------------------------------
On datastage
1. update $DSHOME/.odbc.ini with following DSN name

[DSN_DATA]
Driver=/usr/lpp/tdodbc/odbc/drivers/tdata.so
Description=NCR 3600 running Teradata V1R5.2
DBCName=dev.domain.com
LastUser=
Username=XXXX
Password=XXXX
Database=Dev
DefaultDatabase=
Username: xxxxxxx
password: xxxxxxx

[TDATA]
Driver=/usr/lpp/tdodbc/odbc/drivers/tdata.so
Description=NCR 3600 running Teradata V1R5.2
DBCName=prod.domain.com
LastUser=
Username=xxxx
Password=xxxx
Database=Prod
DefaultDatabase=
[dBase]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMdbf22.so
Description=DataDirect dBaseFile(*.dbf) Driver
ApplicationUsingThreads=1


2. run dsenv