Teradata DBA: 2017

Thursday, April 6, 2017

Why DIP or DIPPATCH did not complete or hung?

Problem

Why DIP or DIPPATCH did not complete or hung?

Environment/Conditions/Configuration

TDBMS 14.10.07.03

Cause

Blocking / leftover HUT locks

Solution

Clear leftover HUT locks:
1) Logon to database as DBC
2) release lock DATABASE_ABC, override;

Additional Information

How to check for locks:

## From lokdips utility
smp0018#
cnsterm 6
Input Supervisor Command:
> start lokdisp
Please enter your selection from the list:
> blocker
Which amp(s) do you want to request on (S=Sampling/A=all/C=cancel/Q=quit):
> all
AMP
182 REPORTS 1 LOCK ENTRIES Number
of Blocked Trans displayed : 1
=========================================
Blocked Trans : 30709 0011AB40
Number of blockers displays : 1
Number of blockers exists : 1
Blocker Trans : 7800 00000001
lock mode : Exclusive
lock status : Granted
lock objectType : Database
lock objectID : DBID : 000003ED
: DBNAME : SYSADMIN
: TableID : 00000000,0000
: TableName : ALL
: RowHashS : 00000000
: RowHashE : 00000000

END OF OUTPUT >
##Showlocks
smp0018#
cnsterm 6
Input Supervisor Command:
> start showlocks
smp0018#
cnsterm 1 (<From
Started
'showlocks' in window 1)

DATABASE_ABC
USER DBC MODE Excl AMP All Amps

DATABASE_DEF
USER DBC MODE Excl AMP All Amps

DATABASE_XYZ
USER DBC MODE Excl AMP All Amps

ShowLocks Processing Complete

Note: Showlocks utility will only show a limit of 6 HUT locks database per screen. If you see 6 locking databases on the screen then note likely there are more. Perform the release lock command and run another showlocks and continue the steps until there are no more locks.

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.

Not able to login from users except DBC

Problem :

Not able to login from users except DBC. Even when the "pdestate a" was displaying "Logons are enabled"

Environment/Conditions/Configuration
ALL TDBMS versions

Cause

When we check the DBC.LogonRules table,there was a default rule for 1024 LogicalHostID which had a LogonStatus as R(Rejected).

This means that no user will be able to login except DBC.

sel UserName
,LogicalHostID
,LogonStatus
from DBC.LogonRules
order by 1,2;

*** Query completed. 6 rows found. 3 columns returned.
*** Total elapsed time was 1 second.

UserName LogicalHostID LogonStatus
Crashdumps
0 G
dbqm 0 G
Default 1024 R
SystemFe 0 G
Sys_Calendar 0 G
tdwm 0 G

Solution

The logon status for Default user in the table "DBC.LogonRules" should be set to 'G'(granted).
Issue the following grant statement to set status to 'G'. grant logon on all as default;

Is it safe to drop old tables in DBC?

Question :

Is it safe to drop old tables in DBC?

Environment/Conditions/Configuration

TDBMS 15.10.01.04b

Answer

Data can be deleted, but do not drop the tables. They are required for restores and migration purposes.

Additional Information
Why are there old versions of dictionary tables ( _V2R6, _TD12, _TD13, _TD14 )?

Q1) Why are there old versions of dictionary tables in DBC?

A1) The old versions of the dictionary tables are there for ARC data migrations. ARC uses these table headers when performing a migration from a previous release of TD.There are two scenarios for these tables:

1) Major upgrades
During major upgrades, the existing dictionary tables have their names changed by tableinit during the first startup on the new major DBS release. The dictionary tables that get recreated by tableinit will have their table names appended with the previous major release. So an upgrade from V2R6 to TD12 would append "_V2R6" to some dictionary table names and then recreate the base dictionary table for that current release. Likewise, then same happens from TD12 to TD13; the tables get appended with "_TD12". Only the table name is being changed by tableinit. All the rows will remain in the old table until the cleanup script is run after the upgrade. When the cleanup script is run, it will only remove the rows from the tables. In this way, the table headers remain on the system.

2) Sysinit
During tableinit after a sysinit, the old versions of the dictionary tables are created as table headers only. For instance, if the system is sysinited at TD14; then tableinit will create the data dictionary tables as well as the required copies of the _TD12 and _TD13 dictionary tables.

Q2) Should the old versions be removed from the system?

A2) No. These tables are required for ARC migrations. If these tables are removed from the system, checktable will report errors and ARC migrations from previous releases will fail!

NOTE: These tables cannot be regenerated without support from the GSC and possibly Engineering. Do not drop the tables without consulting with the GSC DBS Team.

Q3) When will the old versions be removed from the system?

A3) The system will maintain the old dictionary tables for the previous 2 releases. During a major upgrade to TD14, the _V2R6 tables will be removed by the 0010 preconversion script. This will leave the _TD12 tables in place, and the tableinit during TD14 startup will create the _TD13 tables. In the case of these tables remaining after a major
upgrade, the rows will be deleted by the cleanup script that should be run some time after the major upgrade is complete. If rows are seen in these tables, then the cleanup script should be run to drop these rows. This will ensure that the table headers remain on the system, as is required.

Q4) What happens if the old versions are not properly removed by the major upgrade scripts?

A4) If the oldest version is not removed by the 0010 script during the preconversion step, then there will be checktable and scandisk errors seen on the next major release. These errors are innocuous and will NOT affect the system.

What does the post_upgrade_cleanup script do?

1) Deletes the contents of the tables that were renamed by tableinit during the upgrade.
In other words if the upgrade was from TD13 to TD14 all of the dictionary tables name {tablename}_TD13 would have their contents deleted.

The tables are not dropped as these tables and their definition are required for restores/migration purposes. The internal DBS code expects these tables to have a well defined and unique Table ID which is why these tables should never be dropped.
The appropriate _TDxx tables will be dropped during the next major upgrade during the 0010.a.pre_upg.pl processing.

2) Deletes field 8 of the table headers created during table conversion.
On an upgrade when the dictionary tables are converted the conversion has to be restartable.
This is achieved by adding a special restart Field 8 into the table header of these dictionary tables.
After the major upgrade is completed this field 8 causes checktable errors to be be generated.
The post_upgrade_cleanup script calls program called cnvdelfld8 which removes Field 8 from the table headers.

3) When will the old {dictionary_tablename}_TDxx tables be dropped from the system?
The appropriate _TDxx tables will be dropped during the next major upgrade during the 0010.a.pre_upg.pl processing. Since we support migrations from the previous 2 major TD releases there will always be two sets of _TDxx tables on the system at any one time.

How to resolve Reserved Word conflicts?

Question :

The script generates a separate report file called reserved words.rpt. How to resolve Reserved Word conflicts?

Environment/Conditions/Configuration :

TDBMS 15.00.04.02

Answer :

To fix reserved words found in tables, either rename the word or enclose the offending name in double quotes ("word" ).

Additional Information :

dbql_out.rpt: These tables will be dropped in the upgrade. If you wish to retain the data move the data to a new database and rename table or you may just delete data in the tables.

The following query can be ran on the 15.10 environment to show which NEW reserved words are added to 15.10

SELECT * FROM TABLE (SYSLIB.SQLRestrictedWords_TBF()) AS t1 WHERE release_introduced > '15.00' AND category = 'R' ;

How to clear out data from DBQL tables

Objective ;

The objective is to be able to clear out DBQL (Database Query Logging) tables quickly in order to minimize locking and blocking

Environment/Conditions/Configuration
All versions of Teradata

Procedure

The quickest and least invasive way to clear out DBQL data is as follows. See the additional information section below about more comprehensive methods and additional options.

1) Optional: You can turn off DBQL logging temporarily while doing this procedure then turn it back on when you are done

2) Create an empty table in a database other than DBC and run an insert/select of all of the DBQL data from the original table into the new empty table

3) Run a delete all on the original DBQL table (Example delete from dbc.dbqlogtbl;). Running a delete all uses something called fastpath which avoids using the transient journal and makes the delete complete fast (in a matter of seconds).

4) Reenable DBQL logging if it was turned off in step 1.

Special Considerations
It is best to avoid doing partial deletes from the original DBQL tables (such as deleting based on a date range) because it can potentially lock the table for long periods of time and cause problems with the system trying to write to the DBQL tables at the same time. Deleting by date ranges from the original table can potentially lock the DBQL table for hours and cause other unintended site effects.

Additional Information

More comprehensive methods are available in the Teradata Database Administration Manuals for each Teradata Version.

How to bring VMS and database down

Product Categories :

HW Node/Server,Server Management,Operating System,Server Management,Teradata Database

Problem

Customer needs support to stop the DBS due to the Host Machine system relocation Environment/Conditions/Configuration TDBMS 14.10.04.01

Solution

Here are the steps:
1. Set maintenance window
2. tpareset x move system
3. psh init 0
4. For cmic, vms, tms type nodes you can just right click in smweb and select power off.
5. Arrays can just be powered off on site.

After move, power up equipment. Once all nodes are up, the database should come up.

Verify: psh pdestate a

Failure - 3523 The user does not have EXECUTE PROCEDURE access to PDCRAdmin.PDCR_PPI_Maintenance_All

Objective :

DIPPATCH failure during upgrade:

*** Failure 3523 The user does not have EXECUTE PROCEDURE access to PDCRAdmin.PDCR_PPI_Maintenance_All

Environment/Conditions/Configuration
TDBMS 15.10.02.05

Procedure
-- > grant execute procedure on PDCRAdmin.PDCR_PPI_Maintenance_All to dbc;

-- > Rerun DIPPATCH

Deadlock issue found when 'SET QUERY_BAND' submitted

Problem :

SET QUERY_BAND cause deadlock issue, since it need to update sessiontbl.

Environment/Conditions/Configuration
All version

Solution

We can avoid to lock sessiontbl with volatile option.With this change, we can avoid this deadlock.

SET QUERY_BAND=xxxx FOR SESSION VOLATILE;

If it is difficult to apply this change, please consult with your CSR for system level setting.

Error Code - 5603 Errors encountered in compiling UDF/XSP/UDM/UDT/JAR.

Question: -

What does the error message: “5603: Errors encountered in compiling UDF/XSP/UDM/UDT/JAR.” mean?

Answer:

What does the error mean?

There was an internal error that resulted in compiler error. Compiler errors usually occur due to errors in the code that runs the database.

Why does the error occur?
Compilation error refers to a state when a compiler fails to compile a piece of computer program source code, either due to errors in the code, or, more unusually, due to errors in the compiler itself.

What should be done when the error is received?
Please contact your support representative and provide the following:

The offending SQL
If the SQL is not available, you can try looking it up on the DBQLogTbl using the SessionID and/or
the Username For example, in order to get all the queries sent with session number [xxxxx], run the following

query:

SELECT QueryText FROM DBC.DBQLogTbl WHERE SessionID='[xxxxx]';

If SessionID is not available, you can find it by looking up DBC.SessionInfo

Stored procedure definition External stored procedure files may reside on the server or the client

TSET on select * from all objects referenced in the stored procedure

Any underlying stored procedures and Data Definition Language Compilation output

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

useradd -g dba -u 666 -d /data/teradata -m teradata

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

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

Enter your logon or BTEQ command:

.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

*** 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

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