PT job with Oracle and Informix ODBC operator error

Tools
N/A

PT job with Oracle and Informix ODBC operator error

Hi,erveryone
I have a problem in using TPT. When i use the Oracle or informix ODBC operator in my a teradata PT job i received a ODBC connect error
or ODBC driver error.

The following is my machine description:
1: Redhat linux 2.6.9
2: Software:
Informix CSDK 2.9
Oracle database 10g
Freetds0.82
TTU 13.00.00.2

perl 5.8.8
DBI 1.608
DBD-ODBC-1.23
unixODBC-2.2.14-p2

The following is my test step:
1: When i set $ODBCHOME=/opt/teradata/client/13.0/odbc_32 and $ODBCINI=/opt/teradata/client/13.0/odbc_32/odbc.ini,
but when i install perl DBD-ODBC i set $ODBCHOME=/usr/local/unixODBC/ect

1:Then i test teradata ODBC DBD-ODBC i get a segament fault.
2:I test ORACLE and Informix perl DBD-ODBC script is successful
3:I test my PT job with Oracle or Informix i get the following error,this is very strange
ODBC_OPERATOR: private log specified: ODBC_rdpfc0_007.MyLog
ODBC_OPERATOR: connecting sessions
ODBC_OPERATOR: TPT17122: Error: unable to connect to data source
ODBC_OPERATOR: TPT17101: Fatal error received from ODBC driver:
STATE=I, CODE=0,
MSG='['
ODBC_OPERATOR: disconnecting sessions
ODBC_OPERATOR: TPT17124: Error: unable to disconnect from data source
ODBC_OPERATOR: TPT17101: Fatal error received from ODBC driver:
STATE=0, CODE=0,
MSG='['
ODBC_OPERATOR: Total processor time used = '0.06 Second(s)'

2: When i set $ODBCHOME=/opt/teradata/client/13.0/odbc_32 and $ODBCINI=/opt/teradata/client/13.0/odbc_32/odbc.ini,
but when i install perl DBD-ODBC i set $ODBCHOME=/opt/teradata/client/13.0/odbc_32

1:Then i can test teradata ODBC DBD-ODBC success
2:But i test ORACLE and Informix all perl DBD-ODBC script is failed
3:I test my PT job with Oracle or Informix i get the following error
{error} STATE=IM003, CODE=0, MSG=[DataDirect][ODBC lib] Specified driver could not be loaded
4:I can test my PT job with Teradata ODBC operator success

So i get my conclusion:
1: Is the TPT ODBC operator compatible other database ODBC driver has limited? I think so, because my perl can connect Oracle
and informix using ODBC interface,but my PT job with ODBC operator can not work.
2: Is the teradata odbc driver can not support my Oracle and Informix ODBC version?
3: I install FreeTDS for sybase odbc connection. And i can test PT sybase ODBC operator job successful,also i can test my perl sysbase ODBC connect success.

If you have any experence with this,please give me a hint,Think you!
4 REPLIES
Teradata Employee

Re: PT job with Oracle and Informix ODBC operator error

TPT and the ODBC operator are only certified with ODBC drivers from DataDirect.

Also, please indicate which version of TPT you are using.
-- SteveF
N/A

Re: PT job with Oracle and Informix ODBC operator error

Thank you for your applying. My TPT version is 13.00.00.2, and i see the document this version have supported the Oracle,Sybase and Sql server ODBC operator.
I can clearly confim that i can connect Oracle database using the sample application(/opt/teradata/client/sample/adhoc).But my TPT job can not work with the
Oracle ODBC operator. If the TPT ODBC operator are not cerified with this ODBC drivers version, i am not sure.

Re: PT job with Oracle and Informix ODBC operator error

Hi Feinholz,

To be more specific, TPT and ODBC operator are only certified with 32 -bit ODBC drivers from Datadirect?

Regards

Teradata Employee

Re: PT job with Oracle and Informix ODBC operator error

TPT 13.0 only runs in 32-bit mode, so yes we are only certified with the 32-bit versions of the drivers.

-- SteveF