===============================================
Teradata client installation on Linux
===============================================
Same steps for Solaries , Suse-Linux and AIX also
Creating a local user for teradata :
Create one local directory for teradata ,then switch in to teradata user and copy the s/w on that teradata home directory location
groupadd -g 1020 dba
useradd -g dba -u 666 -d /export/home/teradata -m teradata
or
useradd -g dba -u 666 -d /data/teradata -m teradata
or
useradd -g dba -u 666 -d /u01/app/teradata -m teradata
Set the password for teradata user :
Password is need to set same as username (teradata) : i.e
passwd teradata
teradata
passwd teradata ----- > Set the password for teradata user
Need to install below required packages :
yum install ksh -y
yum install libstdc++.so.6 -y
x86_64.rpm --- > 64 bit
i386.rpm ---> 32 bit
Copy the s/w from mount location to teradata user local directory :
su - teradata
After copy the s/w in home directory run gunzip and tar commands for extracting the files
like
gunzip TeradataToolsAndUtilitiesBase__Linux_i386x8664.15.10.00.00.tar.gz
tar -xvf TeradataToolsAndUtilitiesBase__Linux_i386x8664.15.10.00.00.tar
In same home directories ,need to run below command
./setup.bat
give "w" option for above 14.10 version ,like 14.10 ,15.00,15.10 client versions
While installing if you get any error like libstdc++.so.6 error
You need to install libstdc++.so.6 by using yum install libstdc++.so.6
After that again you can install teradata client or remove existing client and intall freshely with w option.
Client installation path : By default installed directory is : /opt/teradata/client/<version>
Ex :
[teradata@hostname TTU15.10]$ cp TeradataToolsAndUtilitiesBase__Linux_i386x8664.15.10.00.00.tar.gz /data1/teradata/
[teradata@hostname TTU15.10]$ exit
logout
[root@hostname ~]# cd /data1/teradata/
[root@hostname teradata]# ls -ltr
-rwxrwxrwx 1 teradata dba 177963657 May 21 2013 viewpoint__SLES10_x8664.13.00.00.03-1.rpm
drwxrwxrwx 3 teradata dba 4096 May 23 2013 TDEXP Linux X86_64 14.02.00.00-1
drwxr-xr-x 5 teradata dba 4096 Jun 6 2013 TD13.10
-rw-r--r-- 1 teradata dba 105534036 Apr 26 14:39 TeradataToolsAndUtilitiesBase__Linux_i386x8664.15.10.00.00.tar.gz
[root@hostname teradata]# mkdir 15.10
[root@hostname teradata]# mv TeradataToolsAndUtilitiesBase__Linux_i386x8664.15.10.00.00.tar.gz 15.10/
[root@hostname teradata]# ls -ltr
-rwxrwxrwx 1 teradata dba 177963657 May 21 2013 viewpoint__SLES10_x8664.13.00.00.03-1.rpm
drwxrwxrwx 3 teradata dba 4096 May 23 2013 TDEXP Linux X86_64 14.02.00.00-1
drwxr-xr-x 5 teradata dba 4096 Jun 6 2013 TD13.10
drwxr-xr-x 2 root root 4096 Apr 26 14:40 15.10
[root@hostname teradata]# cd 15.10/
[root@hostname 15.10]# ls -ltr
-rw-r--r-- 1 teradata dba 105534036 Apr 26 14:39 TeradataToolsAndUtilitiesBase__Linux_i386x8664.15.10.00.00.tar.gz
[root@hostname 15.10]# gunzip TeradataToolsAndUtilitiesBase__Linux_i386x8664.15.10.00.00.tar.gz
[root@hostname 15.10]# ls -ltr
-rw-r--r-- 1 teradata dba 106936320 Apr 26 14:39 TeradataToolsAndUtilitiesBase__Linux_i386x8664.15.10.00.00.tar
[root@hostname 15.10]# tar -xvf TeradataToolsAndUtilitiesBase__Linux_i386x8664.15.10.00.00.tar
Linux/i386-x8664/
Linux/i386-x8664/npaxsmod/
Linux/i386-x8664/npaxsmod/npaxsmod1510-15.10.00.00-1.noarch.rpm
Linux/i386-x8664/fastexp/
Linux/i386-x8664/fastexp/fastexp-15.10.00.00-1.i386.rpm
Linux/i386-x8664/mload/
Linux/i386-x8664/mload/mload-15.10.00.00-1.i386.rpm
Linux/i386-x8664/tdicu/
Linux/i386-x8664/tdicu/tdicu-15.10.00.00-1.noarch.rpm
Linux/i386-x8664/tptstream/
Linux/i386-x8664/tptstream/tptstream1510-15.10.00.00-1.noarch.rpm
Linux/i386-x8664/bteq/
Linux/i386-x8664/bteq/bteq-15.10.00.00-1.i386.rpm
Linux/i386-x8664/jmsaxsmod/
Linux/i386-x8664/jmsaxsmod/jmsaxsmod1510-15.10.00.00-1.noarch.rpm
Linux/i386-x8664/tpump/
Linux/i386-x8664/tpump/tpump-15.10.00.00-1.i386.rpm
Linux/i386-x8664/tptbase/
Linux/i386-x8664/tptbase/tptbase1510-15.10.00.00-1.noarch.rpm
Linux/i386-x8664/fastld/
Linux/i386-x8664/fastld/fastld-15.10.00.00-1.i386.rpm
Linux/i386-x8664/mqaxsmod/
Linux/i386-x8664/mqaxsmod/mqaxsmod1510-15.10.00.00-1.noarch.rpm
Linux/i386-x8664/piom/
Linux/i386-x8664/piom/piom-15.10.00.00-1.noarch.rpm
Linux/i386-x8664/sqlpp/
Linux/i386-x8664/sqlpp/sqlpp-15.10.00.00-1.noarch.rpm
Linux/i386-x8664/cliv2/
Linux/i386-x8664/cliv2/cliv2-15.10.00.00-1.noarch.rpm
Linux/i386-x8664/tdodbc/
Linux/i386-x8664/tdodbc/tdodbc-15.10.00.00-1.noarch.rpm
Linux/i386-x8664/TeraGSS/
Linux/i386-x8664/TeraGSS/TeraGSS_linux_x64-15.10.00.00-1.noarch.rpm
Linux/i386-x8664/tdwallet/
Linux/i386-x8664/tdwallet/tdwallet1510-15.10.00.00-1.noarch.rpm
TeraJDBC/
TeraJDBC/terajdbc4.jar
TeraJDBC/readme.txt
TeraJDBC/tdgssconfig.jar
.setup.sh
setup.bat
MEDIALABEL
uninstall_ttu.sh
tar_teradata_client_packages.bat
tar_teradata_client_packages.sh
[root@hostname 15.10]# ls -ltr
-rwxrwxr-x 1 54381 49173 299 Apr 14 2009 setup.bat
-rwxrwxr-x 1 54381 49173 24345 Apr 29 2014 tar_teradata_client_packages.bat
-rwxrwxr-x 1 54381 49173 17328 Apr 29 2014 tar_teradata_client_packages.sh
drwxrwxr-x 2 54381 49173 4096 Dec 26 2014 TeraJDBC
-rwxrwxr-x 1 54381 49173 34941 Jan 30 2015 uninstall_ttu.sh
-rw-rw-r-- 1 54381 49173 15 Feb 12 2015 MEDIALABEL
-rw-r--r-- 1 teradata dba 106936320 Apr 26 14:39 TeradataToolsAndUtilitiesBase__Linux_i386x8664.15.10.00.00.tar
drwxr-xr-x 3 root root 4096 Apr 26 14:41 Linux
[root@hostname 15.10]# ./setup.bat
#############
###
###
### ###### ####### ## ###### ## ######### ##
### ## ## ## #### ## ## #### ## ####
### ## ## ## ## ## ## ## ## ## ## ## ##
### ## ## ## ## ## ## ## ## ## ## ## ##
### ##### ## ## ## ## ## ## ## ## ## ## ##
### ## ## ## ###### ## ## ## ###### ## ## ###### ##
### ## ## ## ## ## ## ## ## ## ## ## ##
### ## ## ## ## ## ## ## ## ## ## ## ##
### ######## #### ## ##### ## ## # ## ##
##
Welcome to the Teradata Tools and Utilities 15.10 installation v.15.10.00.04
Copyright 2002-2015 by Teradata. All rights reserved.
IF YOU OR THE ENTITY FOR WHOM YOU ARE INSTALLING THIS SOFTWARE DOES NOT HAVE
A WRITTEN LICENSE AGREEMENT WITH TERADATA FOR THIS SOFTWARE, DO NOT INSTALL,
USE, OR ALLOW USE OF THIS SOFTWARE.
Platform: Linux 64bit
Media: TTU Foundation
There is a previous release installed that is incompatible with the
version of TTU to be installed. The 15.00 TTU Client Software should
be removed before installing 15.10.
The previously installed packages can be automatically removed at this time.
Enter "Yes" to remove the pre-15.10 packages and continue with the
installation or "No" to cancel the installation? ([y/n] default: Y): y
Removing packages prior to version 15.10.00.00.
Package Removal Type: rpm
............................................................................
The following packages are installed:
1. bteq - 15.00.00.00
2. fastexp - 15.00.00.00
3. fastld - 15.00.00.00
4. jmsaxsmod1500 - 15.00.00.00
5. mload - 15.00.00.00
6. mqaxsmod1500 - 15.00.00.00
7. npaxsmod1500 - 15.00.00.00
8. sqlpp - 15.00.00.00
9. tdodbc - 15.00.00.01
10. tdwallet1500 - 15.00.00.00
11. tptstream1500 - 15.00.00.00
12. tpump - 15.00.00.00
13. tptbase1500 - 15.00.00.00
14. piom - 15.00.00.00
15. cliv2 - 15.00.00.00
16. tdicu - 15.00.00.00
17. TeraGSS_linux_x64 - 15.00.00.00
Removing: bteq-15.00.00.00 - 15.00.00.00
Removing: fastexp-15.00.00.00 - 15.00.00.00
Removing: fastld-15.00.00.00 - 15.00.00.00
Removing: jmsaxsmod1500-15.00.00.00 - 15.00.00.00
Removing: mload-15.00.00.00 - 15.00.00.00
Removing: mqaxsmod1500-15.00.00.00 - 15.00.00.00
Removing: npaxsmod1500-15.00.00.00 - 15.00.00.00
Removing: sqlpp-15.00.00.00 - 15.00.00.00
Removing: tdodbc-15.00.00.01 - 15.00.00.01
Removing: tdwallet1500-15.00.00.00 - 15.00.00.00
Removing: tptstream1500-15.00.00.00 - 15.00.00.00
Removing: tpump-15.00.00.00 - 15.00.00.00
Removing: tptbase1500-15.00.00.00 - 15.00.00.00
Removing: piom-15.00.00.00 - 15.00.00.00
Removing: cliv2-15.00.00.00 - 15.00.00.00
Executing post-uninstall script../...
Removing COPLIB/COPERR from /etc/profile if cliv2.
Removing CLI tdmst entry from /etc/services
Removing: tdicu-15.00.00.00 - 15.00.00.00
Removing: TeraGSS_linux_x64-15.00.00.00 - 15.00.00.00
...................................................
1. bteq - 15.10.00.00 - Teradata BTEQ Application 735 KB
2. fastexp - 15.10.00.00 - Teradata FastExport Utility 753 KB
3. fastld - 15.10.00.00 - Teradata FastLoad Utility 538 KB
4. jmsaxsmod - 15.10.00.00 - Teradata JMS Access Module 197 KB
5. mload - 15.10.00.00 - Teradata MultiLoad Utility 756 KB
6. mqaxsmod - 15.10.00.00 - WebSphere(r) Access Module for Teradata 804 KB
7. npaxsmod - 15.10.00.00 - Teradata Named Pipes Access Module 220 KB
8. sqlpp - 15.10.00.00 - Teradata C Preprocessor 1895 KB
9. tdodbc - 15.10.00.00 - Teradata ODBC Driver 48666 KB
10. tdwallet - 15.10.00.00 - Teradata Wallet Utility 10515 KB
11. tptbase - 15.10.00.00 - Teradata Parallel Transporter Base 128634 KB
12. tptstream - 15.10.00.00 - Teradata Parallel Transporter Stream 2709 KB
13. tpump - 15.10.00.00 - Teradata TPump Utility 964 KB
Total Dependency Packages Size : 126043 KB
a. Install all of the above software (except Teradata Wallet)
w. Install all of the above software (including Teradata Wallet)
u. Remove previously installed Teradata Tools and Utilities software (pre 1510)
q. Quit the installation
Enter one or more selections (separated by space): w
Installing: TeraGSS_linux_x64-15.10.00.00
Preparing... ########################################### [100%]
1:TeraGSS_linux_x64 ########################################### [100%]
Installing: tdicu
Preparing... ########################################### [100%]
1:tdicu ########################################### [100%]
updating /etc/csh.login and /etc/profile
setting soft links in /usr/lib and /usr/lib64
Installing: tdodbc
Preparing... ########################################### [100%]
1:tdodbc ########################################### [100%]
set_default_version -b 32 -v 15.10 -i /opt
ADDING SYMBOLIC LINK:
source: /opt/teradata/client/ODBC_32/lib
target: /opt/teradata/client/15.10/lib
symbolic link trail:
[1] +-> [/opt/teradata/client/ODBC_32/lib]
[2] +-> [/opt/teradata/client/15.10/lib: directory]
ADDING SYMBOLIC LINK:
source: /opt/teradata/client/ODBC_32/locale
target: /opt/teradata/client/15.10/odbc_32/locale
symbolic link trail:
[1] +-> [/opt/teradata/client/ODBC_32/locale]
[2] +-> [/opt/teradata/client/15.10/odbc_32/locale: directory]
ADDING SYMBOLIC LINK:
source: /opt/teradata/client/ODBC_32/include
target: /opt/teradata/client/15.10/include
symbolic link trail:
[1] +-> [/opt/teradata/client/ODBC_32/include]
[2] +-> [/opt/teradata/client/15.10/include: directory]
set_default_version -b 64 -v 15.10 -i /opt
ADDING SYMBOLIC LINK:
source: /opt/teradata/client/ODBC_64/lib
target: /opt/teradata/client/15.10/lib64
symbolic link trail:
[1] +-> [/opt/teradata/client/ODBC_64/lib]
[2] +-> [/opt/teradata/client/15.10/lib64: directory]
ADDING SYMBOLIC LINK:
source: /opt/teradata/client/ODBC_64/locale
target: /opt/teradata/client/15.10/odbc_64/locale
symbolic link trail:
[1] +-> [/opt/teradata/client/ODBC_64/locale]
[2] +-> [/opt/teradata/client/15.10/odbc_64/locale: directory]
ADDING SYMBOLIC LINK:
source: /opt/teradata/client/ODBC_64/include
target: /opt/teradata/client/15.10/include
symbolic link trail:
[1] +-> [/opt/teradata/client/ODBC_64/include]
[2] +-> [/opt/teradata/client/15.10/include: directory]
Setting soft links in /usr/lib
Setting soft links in /usr/lib64
============================================================================
*** IMPORTANT ODBC USER BULLETIN ***
============================================================================
The TTU 13.0 release has introduced a new TTU directory tree structure
which has unified all the TTU products under a common TTU release directory.
The ODBC 13.0 installation package has taken steps to make this new tree
structure transparent to the existing ODBC users that have selected the
default install directory when installing an ODBC release prior to 13.0.
In the case where the user has selected a non-default install directory,
the user will need to follow the instructions that are documented in the
ODBC README file.
In either case, it is strongly recommended that the user read the ODBC README
file to understand the new TTU tree structure and how it relates to the
ODBC Driver and its odbc.ini and odbcinst.ini files.
============================================================================
*** IMPORTANT ODBC USER BULLETIN ***
============================================================================
Installing: cliv2
Preparing... ########################################### [100%]
1:cliv2 ########################################### [100%]
Adding tdmst entry to /etc/services file.
setting soft links in /usr/lib
Installing: piom
Preparing... ########################################### [100%]
1:piom ########################################### [100%]
Installing: mqaxsmod1510
Preparing... ########################################### [100%]
1:mqaxsmod1510 ########################################### [100%]
Installing: npaxsmod1510
Preparing... ########################################### [100%]
1:npaxsmod1510 ########################################### [100%]
Installing: bteq
Preparing... ########################################### [100%]
1:bteq ########################################### [100%]
Installing: fastexp
Preparing... ########################################### [100%]
1:fastexp ########################################### [100%]
Installing: fastld
Preparing... ########################################### [100%]
1:fastld ########################################### [100%]
Installing: mload
Preparing... ########################################### [100%]
1:mload ########################################### [100%]
Installing: sqlpp
Preparing... ########################################### [100%]
1:sqlpp ########################################### [100%]
Installing: tdwallet1510
Preparing... ########################################### [100%]
1:tdwallet1510 ########################################### [100%]
Installing: tpump
Preparing... ########################################### [100%]
1:tpump ########################################### [100%]
Installing: tptbase1510
Preparing... ########################################### [100%]
1:tptbase1510 ########################################### [100%]
Installing: tptstream1510
Preparing... ########################################### [100%]
1:tptstream1510 ########################################### [100%]
Installing: jmsaxsmod1510
Preparing... ########################################### [100%]
1:jmsaxsmod1510 ########################################### [100%]
Note: Teradata Access Module for JMS requires JRE 1.4 or later.
Set the PATH variable to point to the appropriate JRE location
before using the Teradata Access Module for JMS.
For more details refer the readme file :
(/opt/teradata/client/15.10/jmsaxsmod/readme).
setting softlinks in /usr/lib and /usr/lib64
INFO: There may be important patches available for the products you just
installed. Please consult the Teradata Software Server for the most
recent version of all products.
[root@hostname 15.10]# cd /opt/teradata/
[root@hostname teradata]# ls -ltr
total 16
lrwxrwxrwx 1 root root 39 May 21 2013 viewpoint -> /var/opt/teradata/viewpoint-13.00.00.03
drwxr-xr-x 8 root root 4096 May 23 2013 TeradataStudioExpress
drwxr-xr-x 2 root root 4096 Jun 6 2013 bin
drwxr-xr-x 8 root root 4096 Jan 29 2015 client
drwxr-xr-x 5 root root 4096 Apr 26 14:45 teragss
[root@hostname teradata]# cd client/
[root@hostname client]# ls -ltr
total 24
dr-xr-xr-x 3 root root 4096 Jan 31 2015 tdwallet
drwxr-xr-x 2 root root 4096 Apr 26 14:42 15.00
drwxr-xr-x 2 root root 4096 Apr 26 14:45 etc
drwxr-xr-x 2 root root 4096 Apr 26 14:46 ODBC_32
drwxr-xr-x 2 root root 4096 Apr 26 14:46 ODBC_64
drwxr-xr-x 15 root root 4096 Apr 26 14:46 15.10
[root@hostname client]# cd 15.00/
[root@hostname 15.00]# ls
ThirdPartyLicensesTTU15.00.txt
[root@hostname 15.00]# cd ..
[root@hostname client]# ls
15.00 15.10 etc ODBC_32 ODBC_64 tdwallet
[root@hostname client]# rm -rf 15.00/
[root@hostname client]# ls -ltr
total 20
dr-xr-xr-x 3 root root 4096 Jan 31 2015 tdwallet
drwxr-xr-x 2 root root 4096 Apr 26 14:45 etc
drwxr-xr-x 2 root root 4096 Apr 26 14:46 ODBC_32
drwxr-xr-x 2 root root 4096 Apr 26 14:46 ODBC_64
drwxr-xr-x 15 root root 4096 Apr 26 14:46 15.10
[root@hostname client]# cd 15.10/
[root@hostname 15.10]# ls -ltr
total 52
drwxr-xr-x 4 root root 4096 Jan 29 2015 sample
drwxr-xr-x 2 root root 4096 Jan 29 2015 etc
drwxr-xr-x 16 root root 4096 Jan 29 2015 tbuild
drwxr-xr-x 6 root root 4096 Apr 26 14:46 odbc_32
drwxr-xr-x 6 root root 4096 Apr 26 14:46 odbc_64
drwxr-xr-x 2 root root 4096 Apr 26 14:46 include
dr-xr-xr-x 4 root root 4096 Apr 26 14:46 tdwallet
drwxr-xr-x 2 root root 4096 Apr 26 14:46 msg
drwxr-xr-x 2 root root 4096 Apr 26 14:46 bin
drwxr-xr-x 2 root root 4096 Apr 26 14:46 lib64
drwxr-xr-x 2 root root 4096 Apr 26 14:46 lib
drwxr-xr-x 2 root root 4096 Apr 26 14:46 jmsaxsmod_64
drwxr-xr-x 2 root root 4096 Apr 26 14:46 jmsaxsmod
Client installed Location :
[root@hostname 15.10]# pwd
/opt/teradata/client/15.10
Client checking :
After installing just run bteq command in linux command line ,like
[root@hostname 15.10]# bteq
Teradata BTEQ 15.10.00.00 for LINUX. PID: 27400
Copyright 1984-2015, Teradata Corporation. ALL RIGHTS RESERVED.
Enter your logon or BTEQ command:
.logon 10.65.42.127/dbc
.logon 10.65.42.127/dbc
Password: ------------- > Password is dbc
*** Logon successfully completed.
*** Teradata Database Release is 14.10.00.00
*** Teradata Database Version is 14.10.00.00
*** Transaction Semantics are BTET.
*** Session Character Set Name is 'ASCII'.
*** Total elapsed time was 1 second.
BTEQ -- Enter your SQL request or BTEQ command:
.quit
.quit
*** You are now logged off from the DBC.
*** Exiting BTEQ...
*** RC (return code) = 0
[root@hostname ~]$
If you see this output,then client is working fine
Or else ,if you see any error while connecting bteq in command line,
Just logout and login from server ,then run bteq command again.
=======================================================
Un-installation Teradata client
To remove client ,
After extracting the home directory folder for teradata user, you will get uninstall_ttu.sh file is there
you can run ./uninstall_ttu.sh file and give option "a" -- >To remove all packages .
hostname:/export/home/teradata/1410 #
hostname:/export/home/teradata/1410 # ls -ltr
total 57396
-rwxrwxr-x 1 713 49173 32025 Feb 1 2013 uninstall_ttu.sh
-rwxrwxr-x 1 713 49173 17206 Feb 1 2013 tar_teradata_client_packages.sh
-rwxrwxr-x 1 713 49173 24217 Feb 1 2013 tar_teradata_client_packages.bat
-rwxrwxr-x 1 713 49173 299 Feb 1 2013 setup.bat
-rwxrwxr-x 1 713 49173 130968 Feb 1 2013 ThirdPartyLicensesTTU14.10.txt
drwxrwsr-x 2 713 49173 4096 Feb 1 2013 TeraJDBC
-rwxrwxr-x 1 713 49173 15 Feb 1 2013 MEDIALABEL
-rwxrwxr-x 1 713 49173 118841 Feb 1 2013 .setup.sh
-rw-r--r-- 1 teradata dba 58354299 Feb 19 14:13 BCD0-1560-0000-Linux-i386-x8664_14.10.00_V1-1_101747728.tar.gz
drwxr-xr-x 3 root root 4096 Feb 19 14:14 Linux
hostname:/export/home/teradata/1410 # ./uninstall_ttu.sh
Teradata Tools and Utilities UNIX Uninstall v.14.10.00.00
Copyright 2009-2013. Teradata Corporation. All Rights Reserved.
Package Removal Type: rpm
................................................................................
The following packages are installed:
1. bteq - 13.10.00.00
2. fastexp - 13.10.00.02
3. fastld - 13.10.00.01
4. mload - 13.10.00.01
5. mqaxsmod - 13.10.00.01
6. npaxsmod - 13.10.00.01
7. pexp_x8664_da00 - 13.10.00.05
8. plod_x8664_da00 - 13.10.00.04
9. pstm_x8664_da00 - 13.10.00.06
10. pupd_x8664_da00 - 13.10.00.04
11. sqlpp - 13.10.00.03
12. tdodbc - 13.10.00.07
13. tpump - 13.10.00.01
14. papi_x8664_da00 - 13.10.00.07
15. piom - 13.10.00.09
16. cliv2 - 13.10.00.11
17. tdicu - 13.10.00.02
18. TeraGSS_redhatlinux - 13.10.00.02
19. TeraGSS_suselinux - 13.10.04.01
f. Display the full package information on the packages listed.
a. Remove all of the above software.
h. Display help information.
q. Quit the package remove script.
Enter one or more selections (separated by space): a
Removing: bteq-13.10.00.00 - 13.10.00.00
No comments:
Post a Comment