All Forums Database
john9 30 posts Joined 05/14
26 Jul 2016
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
 
 

Fred 1096 posts Joined 08/04
26 Jul 2016

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

M.Saeed Khurram 544 posts Joined 09/12
27 Jul 2016

This has already been answered at
https://forums.teradata.com/forum/tools/tpt17122-error-unable-to-connect-to-data-sourceoracle-using-tpt-script

Khurram

john9 30 posts Joined 05/14
27 Jul 2016

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

You must sign in to leave a comment.