TPT ODBC

Database
Enthusiast

TPT ODBC

Hi All  -

I have been struggling to fix my ODBC TPT script.Here is the back ground:

My teredata version is 14.10

I am trying to extract the data from AS400 (accessed through DB2 client) using ODBC TPT script.

Below is the error message i am getting:

Teradata Parallel Transporter Version 14.10.00.02

Job log: /opt/teradata/client/14.10/tbuild/logs/rpuuat-6662.out

Job id is rpuuat-6662, running on uat

Found CheckPoint file: /opt/teradata/client/14.10/tbuild/checkpoint/rpuuatLVCP

This is a restart job; it restarts at step Insert_Into_Tables.

Teradata Parallel Transporter Load Operator Version 14.10.00.02

Load_Operator: private log specified: load_log

Teradata Parallel Transporter ODBC Operator Version 14.10.00.02

ODBC_Operator: private log specified: odbc_log-1

ODBC_Operator: connecting sessions

ODBC_Operator: TPT17122: Error: unable to connect to data source

ODBC_Operator: TPT17101: Fatal error received from ODBC driver:

STATE=81, CODE=0,

MSG='523 80'

ODBC_Operator: disconnecting sessions

ODBC_Operator: TPT17124: Error: unable to disconnect from data source

ODBC_Operator: TPT17101: Fatal error received from ODBC driver:

STATE=53, CODE=0,

MSG='523 52'

ODBC_Operator: Total processor time used = '0.01 Second(s)'

ODBC_Operator: Start : Tue Jul 26 14:15:21 2016

ODBC_Operator: End : Tue Jul 26 14:15:22 2016

Load_Operator: connecting sessions

Load_Operator: preparing target table

Load_Operator: entering Acquisition Phase

Load_Operator: disconnecting sessions

Load_Operator: Total processor time used = '1.61 Second(s)'

Load_Operator: Start : Tue Jul 26 14:15:21 2016

Load_Operator: End : Tue Jul 26 14:15:27 2016

Job step Insert_Into_Tables terminated (status 12)

Job rpuuat terminated (status 12)

Job start: Tue Jul 26 14:15:18 2016

Job end: Tue Jul 26 14:15:27 2016

We already have a datastage job which is used to pull the data from this source (AS400) .So can some help me how to extract the data using pure TPT ODBC script?

Please let me know if you need any additional details.

Thanks

3 REPLIES
Teradata Employee

Re: TPT ODBC

See http://knowledgebase.progress.com/articles/Article/3556 for information regarding this error.

Enthusiast

Re: TPT ODBC

Enthusiast

Re: TPT ODBC

Thank you both for the reply ...i will check and get back to you.