All Forums Tools
shubhendu.pyne 5 posts Joined 06/15
25 Jun 2015
TPT For Informatica 9.0.1

Hi,
I have Informatica 9.0.1 running on Solaris 10 Sparc. I installed the content from tdodbc1400__solaris_sparc.14.00.00.04.tar.gz but still unable to get the TPT working. In the Informatica Relational Loader, unable to see TPT. My target database is TD 14.00
Can someone please help me know :-
1. If i had installed correct package for TPT?
2. Download link for TPT
3. If TPT already present in the above said zip, please help me know what to check to confirm its installed.
Thanks & Regards,
Shubhendu
6105331174

feinholz 1234 posts Joined 05/08
25 Jun 2015

A couple of things.
1. you can use the platform appropriate package command (e.g. pkginfo) to see if the TPT package was installed.
2. from a command prompt on the machine on which you installed TPT, you can type "tbuild -v" (without quotes) and if you get the TPT output showing the version number, you know TPT was installed.
Other than that, please check with Informatica to determine why you do not see TPT in the IRL.
 

--SteveF

shubhendu.pyne 5 posts Joined 06/15
02 Jul 2015

Hi All,
I sucessfully installed TPT sucessfully & its sucessfully integrated with Informatica 9.0.1.
Issue :-
On Solaris 10 Sparc, while running the BTEQ i am getting this error :-

$ bteq

 

 Teradata BTEQ 13.10.00.16 for SOLARIS/SPARC.

 Copyright 1984-2015, Teradata Corporation. ALL RIGHTS RESERVED.

 Enter your logon or BTEQ command:

.LOGON 10.212.200.133/CSS_ETL

 

.LOGON 10.212.200.133/CSS_ETL

Password:

 

 *** CLI error: MTDP: EM_GSSINITFAIL(235): call to gss_init failed.

 *** Return code from CLI is: 235

 *** Error: Logon failed!

 

 *** Total elapsed time was 5 seconds.

 

Packages Installed :-

 

$ pkginfo -l TeraGSS

   PKGINST:  TeraGSS

      NAME:  Teradata GSS client package

  CATEGORY:  system

      ARCH:  Solaris/SPARC

   VERSION:  13.10.07.09

   BASEDIR:  /

    VENDOR:  Teradata Corporation

    PSTAMP:  esssol00920130814110927

  INSTDATE:  Jul 02 2015 00:21

    STATUS:  completely installed

     FILES:       99 installed pathnames

                  12 directories

                  86 executables

               77365 blocks used (approx)

 

$ pkginfo -l cliv21310

   PKGINST:  cliv21310

      NAME:  Teradata CLIV2 Library

  CATEGORY:  application

      ARCH:  Solaris9/SPARC

   VERSION:  13.10.00.14

   BASEDIR:  /opt

    VENDOR:  Teradata Corporation

    PSTAMP:  esssol00920130619162422

  INSTDATE:  Jul 02 2015 00:22

    STATUS:  completely installed

     FILES:       30 installed pathnames

                   7 shared pathnames

                   7 directories

                   7 executables

                2550 blocks used (approx)

 

$ pkginfo -l tdicu1310

   PKGINST:  tdicu1310

      NAME:  Shared common components for Internationalization for Teradata

  CATEGORY:  library

      ARCH:  Solaris9/SPARC

   VERSION:  13.10.00.02

   BASEDIR:  /opt

    VENDOR:  Teradata Corporation

    PSTAMP:  esssol00920101203134934

  INSTDATE:  Jul 02 2015 00:21

    STATUS:  completely installed

     FILES:       18 installed pathnames

                   3 shared pathnames

                   6 directories

               44583 blocks used (approx)

 

$ pkginfo -l bteq1310

   PKGINST:  bteq1310

      NAME:  Teradata BTEQ Utility

  CATEGORY:  application

      ARCH:  Solaris9/SPARC

   VERSION:  13.10.00.16

   BASEDIR:  /opt

    VENDOR:  Teradata Corporation

    PSTAMP:  esssol00920150420073531

  INSTDATE:  Jul 02 2015 00:26

    STATUS:  completely installed

     FILES:       10 installed pathnames

                   6 shared pathnames

                   6 directories

                   4 executables

                1717 blocks used (approx)

 

Paths :-

 

$ echo $LD_LIBRARY_PATH

/opt/webapps/oracle/product/11.2.0.1/lib:/opt/webapps/Informatica901/server/bin:/opt/teradata/client/odbc/lib:/opt/teradata/client/13.10/lib64:/opt/teradata/client/13.10/tbuild/lib64:/usr/lib

 

Request  :-

 

Please help me resolve this issue. We are going to use BTEQ on CLI for Teradata to Teradata data loading with transformation.

 

Please let me know if you need more information.

 

Thanks & Regards,

Shubhendu

 

shubhendu.pyne 5 posts Joined 06/15
02 Jul 2015

Missed this information
Order of installation was :-

pkgadd -d `pwd` TeraGSS

pkgadd -d `pwd` tdicu1310

pkgadd -d `pwd` cliv21310

pkgadd -d `pwd` tdodbc1310

pkgadd -d `pwd` piom1310

pkgadd -d `pwd` bteq1310

pkgadd -d `pwd` fastexp1310

pkgadd -d `pwd` fastld1310

pkgadd -d `pwd` jmsaxsmod1310

pkgadd -d `pwd` mload1310

pkgadd -d `pwd` mqaxsmod1310

pkgadd -d `pwd` npaxsmod1310

pkgadd -d `pwd` papida00

pkgadd -d `pwd` pexpda00

pkgadd -d `pwd` plodda00

pkgadd -d `pwd` pstmda00

pkgadd -d `pwd` pupdda00

pkgadd -d `pwd` sqlpp1310

pkgadd -d `pwd` tbldda00

pkgadd -d `pwd` tpump1310

Please help me how to resolve the issue.

feinholz 1234 posts Joined 05/08
02 Jul 2015

The title of this thread should not have TPT in the title, since it is a problem or question regarding BTEQ.
 

--SteveF

Fred 1096 posts Joined 08/04
03 Jul 2015

Your LD_LIBRARY_PATH contains the 64-bit library: /opt/teradata/client/13.10/lib64
BTEQ is 32-bit; make sure the scripts calling BTEQ use /opt/teradata/client/13.10/lib instead.

You must sign in to leave a comment.