ODBC connect to DB2 in TPT - TPT_INFRA: TPT02192: Error: Cannot load shared library

Connectivity

ODBC connect to DB2 in TPT - TPT_INFRA: TPT02192: Error: Cannot load shared library

Hi,

I'm writing a TPT script to connect to DB2 with ODBC. The ODBC DB2 drivers are 64 bit. I'm running on AIX unix. Below is the error, some teradata libraries, and the tpt script. Please let me know if you need any additional information. Thank you for your help.

/home/idxxx >> tbuild -f load_db2_connect.tpt

Teradata Parallel Transporter Version 14.00.00.08

Job log: /opt/teradata/client/14.00/tbuild/logs/idxxx-1.out

Job id is idxxx-1, running on etlpxapp01

Teradata Parallel Transporter SQL DDL Operator Version 14.00.00.08

DDL_OPERATOR: private log not specified

DDL_OPERATOR: connecting sessions

DDL_OPERATOR: sending SQL requests

DDL_OPERATOR: TPT10508: RDBMS error 3807: Object 'cm_raw.sss_kids_001_ET' does not exist.

DDL_OPERATOR: TPT18046: Warning: error is ignored as requested in ErrorList

DDL_OPERATOR: TPT10508: RDBMS error 3807: Object 'cm_raw.sss_kids_001_UV' does not exist.

DDL_OPERATOR: TPT18046: Warning: error is ignored as requested in ErrorList

DDL_OPERATOR: TPT10508: RDBMS error 3807: Object 'cm_raw.sss_kids_001_LG' does not exist.

DDL_OPERATOR: TPT18046: Warning: error is ignored as requested in ErrorList

DDL_OPERATOR: Rows Deleted:  0

DDL_OPERATOR: disconnecting sessions

DDL_OPERATOR: Total processor time used = '0.03316 Second(s)'

DDL_OPERATOR: Start : Sat May 21 08:18:25 2016

DDL_OPERATOR: End   : Sat May 21 08:18:26 2016

Job step Setup_Tables completed successfully

TPT_INFRA: TPT02192: Error: Cannot load shared library

           dlopen error: Could not load module /opt/teradata/client/14.00/tbuild/lib/libodbcop.so.

        Dependent module /etl/IBM/InformationServer/Server/branded_odbc/lib/libodbc.a(odbc.so) could not be loaded.

        The module has an invalid magic number.

Could not load module /opt/teradata/client/14.00/tbuild/lib/libodbcop.so.

        Dependent module /opt/teradata/client/14.00/tbuild/lib/libodbcop.so could not be loaded.

TPT_INFRA: TPT02109: Cannot open shared library libodbcop.so, status = Open Error

TPT_INFRA: TPT02240: Error: Cannot create operator object, status = Operator Error

TPT_INFRA: TPT02103: Executor unable to set up its table object

Job step load_ld_table_from_file terminated (status 12)

Job idxxx terminated (status 12)

/home/idxxx >> cd /opt/teradata/client

/opt/teradata/client >> ls

13.10    14.00    ODBC_32  ODBC_64  lib      odbc

/opt/teradata/client >> cd 14.00

/opt/teradata/client/14.00 >> ls

bin        bin64      include    jmsaxsmod  lib        lib64      odbc_32    odbc_64    sample     tbuild     tdicu

/opt/teradata/client/14.00 >> cd tbuild

/opt/teradata/client/14.00/tbuild >> ls

bin          inc          lib64        mmap         msg64        template     twbcfg.ini   version

checkpoint   lib          logs         msg          sample       tptapi       twboper.ini

/opt/teradata/client/14.00/tbuild >> cd lib

/opt/teradata/client/14.00/tbuild/lib >> ls -l

total 25883

-r--r--r--    1 root     system      1699794 Nov 06 2012  libdataconop.so

-r--r--r--    1 root     system        57885 Nov 06 2012  libddlop.so

-r--r--r--    1 root     system       150155 Nov 06 2012  libexportop.so

-r--r--r--    1 root     system      1323861 Nov 06 2012  libfeomop.so

-r--r--r--    1 root     system      1313447 Nov 06 2012  libflimop.so

-r--r--r--    1 root     system       114051 Nov 06 2012  libinsertop.so

-r--r--r--    1 root     system       133003 Nov 06 2012  libloadop.so

-r--r--r--    1 root     system        66441 Nov 06 2012  liblogview.so

-r--r--r--    1 root     system      1320615 Nov 06 2012  libmlimop.so

-r--r--r--    1 root     system       303270 Nov 06 2012  libodbcop.so

-r--r--r--    1 root     system       589734 Nov 06 2012  libopcommon.so

-r--r--r--    1 root     system        14449 Nov 06 2012  liboscmdop.so

-r--r--r--    1 root     system       175748 Nov 06 2012  libptmin.so

-r--r--r--    1 root     system        38972 Nov 06 2012  libptmos.so

-r--r--r--    1 root     system       208157 Nov 06 2012  libptmpi.so

-r--r--r--    1 root     system        87385 Nov 06 2012  libptmpo.so

-r--r--r--    1 root     system      2893405 Nov 06 2012  libpxcommon.so

-r--r--r--    1 root     system       207750 Nov 06 2012  libpxextrct.so

-r--r--r--    1 root     system        15128 Nov 06 2012  libpxicu.so

-r--r--r--    1 root     system        59485 Nov 06 2012  libschemapop.so

-r--r--r--    1 root     system       133719 Nov 06 2012  libselectop.so

-r--r--r--    1 root     system       367906 Nov 07 2012  libstreamop.so

-r--r--r--    1 root     system       487007 Nov 06 2012  libtableqry.so

-r--r--r--    1 root     system      1314970 Nov 06 2012  libtelapi.so

-r--r--r--    1 root     system       133534 Nov 06 2012  libupdateop.so

/opt/teradata/client/14.00/tbuild/lib >> cd ../lib64

/opt/teradata/client/14.00/tbuild/lib64 >> ls -l

total 6201

-r--r--r--    1 root     system       164098 Nov 06 2012  libexportop.so

-r--r--r--    1 root     system       142112 Nov 06 2012  libloadop.so

-r--r--r--    1 root     system       638313 Nov 06 2012  libopcommon.so

-r--r--r--    1 root     system        16604 Nov 06 2012  libpxicu.so

-r--r--r--    1 root     system       396336 Nov 07 2012  libstreamop.so

-r--r--r--    1 root     system      1666588 Nov 06 2012  libtelapi.so

-r--r--r--    1 root     system       142887 Nov 06 2012  libupdateop.so

tpt script:

/***********************************************************************

-- This script mloads a table reading a flat file using LOAD operator

-- MANUAL UPDATES WERE MADE by xxxx on mm/dd/yyyy.

-- MANUAL UPDATES WERE MADE by xxxx on mm/dd/yyyy.

*************************************************************************/

DEFINE JOB FILE_LOAD

DESCRIPTION ' This TPT script is used to load a flat file to a table. '

(

DEFINE SCHEMA ACTIVE_EMPS_schema

(

   CORP_ENT_CD CHAR(10)                           /* 1   8   1   - 8          */

  ,SRC_REC_STA_CD CHAR(1)                         /* 2   5   9   - 13         */

);

DEFINE OPERATOR  DDL_OPERATOR

DESCRIPTION 'TPT DDL OPERATOR - do initial table prep work items.'

TYPE DDL

ATTRIBUTES

(

 VARCHAR TdpId = 'edwp',

 VARCHAR UserName = 'idxxx',

 VARCHAR UserPassword = 'xxxx',

 VARCHAR ErrorList = '3807'

);

DEFINE OPERATOR  ODBC_OPERATOR

DESCRIPTION 'TPT ODBC OPERATOR - connect to db2.'

TYPE ODBC

SCHEMA ACTIVE_EMPS_schema

ATTRIBUTES

(

 VARCHAR DSNname = 'IDSPRDDA',

 VARCHAR UserName = 'idxxx',

 VARCHAR UserPassword = 'wwww',

 VARCHAR SelectStmt = 'select corp_ent_cd, src_rec_sta_cd from PODDB01.pty_key_mgmt fetch first 1 rows only with ur;'

);

DEFINE OPERATOR LOAD_OPERATOR

TYPE LOAD

SCHEMA *

ATTRIBUTES

(

 VARCHAR TdpId = 'edwp',

 VARCHAR UserName = 'idxxx',

 VARCHAR UserPassword = 'xxxx',

 VARCHAR TargetTable = 'cm_raw.sss_kids_001',

 VARCHAR LogTable = 'cm_raw.sss_kids_001_LG',

 VARCHAR ErrorTable1 = 'cm_raw.sss_kids_001_ET',

 VARCHAR ErrorTable2 = 'cm_raw.sss_kids_001_UV',

 INTEGER MaxSessions = 4,

 INTEGER MinSessions = 1,

 INTEGER ErrorLimit = 99999999

);

STEP Setup_Tables

(

APPLY

 ('DROP TABLE cm_raw.sss_kids_001_ET;'),

 ('DROP TABLE cm_raw.sss_kids_001_UV;'),

 ('DROP TABLE cm_raw.sss_kids_001_LG;'),

 ('DELETE FROM cm_raw.sss_kids_001;')

TO OPERATOR (DDL_OPERATOR);

);

STEP load_ld_table_from_file

(

APPLY

  ('INSERT INTO cm_raw.sss_kids_001(

   :CORP_ENT_CD

  ,:SRC_REC_STA_CD

  );')

TO OPERATOR (LOAD_OPERATOR)

SELECT * FROM OPERATOR(ODBC_OPERATOR);

);

);

);