Tuesday, March 21, 2017

Teradata client installation on Linux



Below 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

Group Creation : groupadd -g 1020 dba

User Creation : 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

I.e

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@hostname15.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@INVIRH54DB2 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 installaed 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]# su - teradata

[root@hostname ~]$ 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.68.42.129/dbc

.logon 10.68.42.129/dbc
Password: -------------  > Password is dbc123

 *** 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
[teradata@INVIRH54DB2 ~]$



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



Would like to install different versions of TTU software on same system.


Question :

Are multiple TTU versions allowed on same system?

Environment/Conditions/Configuration :

Informatica server

Answer :

Multiple TTU versions installed on the same system is not allowed. This is an uncertified/unsupported configuration.

What is 7593 error and how to avoid it?



Problem :

What is 7593 error and how to avoid it?

# Below are error text samples from DBQL.

Error limit of 1 is reached; errors logged in ABCD_ERR where ETC_dbql_qid = 163829702788291360.

Error limit of 1 is reached; errors logged in ABCD_ERR where ETC_dbql_qid = 163829702788467780.


Environment/Conditions/Configuration :

TDBMS 14.10.06.05


Cause  :

Error 7593 occurs when error limit logging has been reached on an INSERTSELECT or MERGEINTO query.


Solution :

To avoid the error:

1) Increase the error limit.

> For example: "LOGGING ALL ERRORS WITH LIMIT OF <larger number>".

2) Review the query and ensure that no error rows will occur (or within the limit) from the MERGEINTO statement.

What does the error message 2639 mean?


Question :

What does the error message 2639 mean?
2639 Too many simultaneous transactions.


Environment/Conditions/Configuration :
all


Answer :

Error 2639 is returned when we hit the limit of transactions in progress on one AMP.
Query needs to be resubmitted.


Additional Information :

2639 Too many simultaneous transactions.

Explanation: This error occurs if a new transaction is initiated but the system cannot accommodate it.
Generated By: AMP Software.

For Whom: End User.

Notes: This error means that an AMP has as many active transactions as it can hold.

Remedy: Resubmit the request.

Bteq login fails with "Warning RDBMS CRASHED OR SESIONS RESET.RECOVERY IN PROGRESS"



Problem :

Database is up on DSADSC .But,Bteq login fails with "Warning: RDBMS CRASHED OR SESIONS
RESET.RECOVERY IN PROGRESS"

bar15a:~ # bteq
Teradata BTEQ 14.10.00.13 for LINUX. PID: 14084
Copyright 19842015,
Teradata Corporation. ALL RIGHTS RESERVED.
Enter your logon or BTEQ command:
.logon systemfe
.logon systemfe
Password:
*** Warning: RDBMS CRASHED OR SESSIONS RESET. RECOVERY IN PROGRESS.


Cause :

Issue with hosts file


Solution :

##In hosts file the localhosts doesn't have alias name dbccop1.So,If we connect to database without mentioning TDPID.Then By default it tries to connect to dbccop1.As it doesn't have entries in hosts file.It's getting from DNS.But,the Entries in DNS returning different Ip address where database not running on those systems and resulting in failure.

/etc/hosts file
Before change:
127.0.0.1 localhost barcop1
After change:
127.0.0.1 localhost dbccop1


Verifying TTU software version information



Question  :

How do you find TTU version information (SQL assistant ,fast load, etc) which users are using?
Environment/Conditions/Configuration TTU software.


Answer  :

Run TTUListProducts. This will give you the version information for each TTU component currently installed.

The gtwcontrol utility cannot be started/executed from the csterm console utility


Problem :

User is not able to run any command gtwcontrol utility when executed from the Teradata csnterm console utlity


Environment/Conditions/Configuration :

TDGTW 15.10.xx


Cause :

Working as designed. Feature is not available through the csnsterm console utility.


Solution :

The gtwcontrol is meant to be executed from a bash terminal, not from csnterm
Special Considerations Customer should be able to access/modify the Gateway values by executing the gtwcontrol on the directory that matches with its release . Using the h option will show you the different options available.


Additional Information  :
TDPDNNODE:
# /usr/tgtw/bin/gtwcontrol h
The /usr/tgtw is symbolically linked to the currently active tgtw version

TASM ruleset activation error


Problem :

We try to activate a ruleset and get this error.
Copying to WORKING rulesets gives same error.
Importing .xml file from what we exported prior to the cutover results in another error:
Cannot import Full TASM Ruleset to a Restricted System.
Red triangle says Internal Error: Contact the dministrator.

Cause :

Hosts file was pointing at the decommissioned Teradata system, not the NPARCed system.

Solution :

Customer modified /etc/hosts to use the correct IP address for the new system.

Not seeing all the defined databases under the space usage portlet in Viewpoint


Problem :

Not seeing all the defined databases under the space usage portlet in Viewpoint, the number of databases showing is less than the actual number of defined database.

Environment/Conditions/Configuration :

Viewpoint 15.00.00.08

Cause :

Known issue with Viewpoint that is addressed by JIRA : VP35575

Solution :
Upgrade to Viewpoint 15.00.00.10 or 15.10.00.00 or later


Special Considerations :
A Viewpoint upgrade is required

Connection from SQLA 15.10 fails - "0: Loading the Teradata ICU Library Failed. Error is 126"


Problem  :

In SQL Assistant, when ODBC is selected and a connection is attempted, a popup
is thrown:

0: Loading the Teradata ICU Library Failed. Error is: 126

.Net connections from SQLA work correctly. Shared ICU for 32bit is shown as installed on TTUListProducts.

Environment/Conditions/Configuration :
TDBMS 15.10.01.07
Windows 8
Windows 10
TTU 15.10
Microsoft Office 2016

Cause :

Windows 8 has no version of the msvcr110.dll library in its 32bit directory:

C:\Windows\SysWOW64 for a 64bit system
C:\Windows\System32 for a 32bit system
ODBC requires the library to operate correctly.

Solution :
Workaround:

Locate the version of msvcr110.dll which is distributed with 32bit
TeraGSS. The location may vary slightly depending on the version of TTU installed. Prior to TTU 15.10.04, the TeraGSS components were installed in

Program Files (x86)\Teradata\Teradata GSS. Beginning with TTU 15.10.04, they were moved to Program Files (x86)\Teradata\Client\15.10\bin.

Copy msvcr110.dll from the Teradata directory to C:\Windows\SysWOW64.
Close and reopen SQL Assistant.

Additional Information :

Another symptom matches KCS001882: the error "Cannot find terasso library" is thrown when the user tries to create a new DSN or configure an existing DSN in ODBC Administrator.

Is it possible to migrate the DataLab from one viewpoint machine to another?


Question :

Customer is using Virtual Viewpoint on one site id for Datalabs.Customer has requested to migrate Datalabs to another baremetal viewpoint (but stay on the same Teradata system) located on other site id..

Is it possible to migrate the datalabs from one viewpoint to other?

Environment/Conditions/Configuration :
viewpoint 14.10

Answer :

Yes,It is possible to migrate the datalab from one viewpoint machine to another.But,Both viewpoint's should be at the same version.

This is documented in the viewpoint configuration guide.

Special Considerations :

Target VP server will lose all of its data in the process

How to resolve checktable error - 2740 One or more rows found for table not in DBC.TVM?


Problem :

How to resolve checktable error: 2740: One or more rows found for table not in DBC.TVM?

Environment/Conditions/Configuration
TDBMS 15.10.01.04

Solution :

Re- ran
checktable on quiescent system.
2740 errors were bogus due to logons were not disabled


Additional Information :

We often see instances where CHECKTABLE is run on an active system. This is not a problem but it can result in bogus errors 2740 and 7437 errors if it happens to catch a table while it is being dropped or created. To check if the error is valid, run a second checktable only against the table on which error is reported.

# psh pdestate a
all 4 nodes:
PDE state is RUN/STARTED.
DBS state is 11: Only user DBC Logons are enabled The
system is quiescent

# cnsterm 1
Attempting to connect to CNS...Completed.
Hello
Enter a command, "QUIT;", "HELP;" or F7 for interactive help:
> check all tables at level pendingop in parallel ;
check all tables at level pendingop in parallel ;
Checktable defaults to concurrent mode
on quiescent system with logons enabled.
Check beginning at 19:31:48 16/08/05.
CHECKTABLE will run from Host: 0 Session: 904,37943
Concurrent mode skips DBC checking for check all tables
><
snip>
>


Summary:

18,104 table(s) checked.
6,700 fallback table(s) checked.
11,404 nonfallback
table(s) checked.
36 no primaryindex
table(s) checked.
0 table(s) failed the check.
Check completed at 19:46:51 16/08/05.
Enter a command, "QUIT;", "HELP;" or F7 for interactive help:
> quit;
Here is how you translate the Table Id into a table name:
Sample checktable error:
7437: Table header not found for a materialized temporary table.
Temporary table ID 8000H D1E3H
2740: One or more rows found for table not in DBC.TVM.
Table Id 0001H 6352H
Rows for table found on all AMPs
The tableid in the message must be byte flipped for SQL:
e.g.
"aa" "bb" "cc" "dd" ‐> bbaa ddcc
so:
0001H 6352H ‐> 01005263

Run the following SQL to determine the Table Name:
==========================================

Locking dbc.dbase For Access

Locking dbc.tvm For Access

SELECT dbase.DatabaseName (char(20))
,tvm.TVMName (char(20))
,tvm.TableKind (char(1) ,title 'T//V//M')
,tvm.ProtectionType (char(1) ,title 'Fall//Back')
FROM dbc.dbase dbase
,dbc.tvm tvm
WHERE (dbase.databaseid = tvm.databaseid)
AND tvm.tvmid in (
'01005263'xb /** see example above for byte‐flip **/
,'02001e3f'xb
) order by 1,2;