If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > DB2 II to Teradata connectivity issue

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-16-05, 09:27
dollar489 dollar489 is offline
Registered User
 
Join Date: Sep 2002
Posts: 456
DB2 II to Teradata connectivity issue

DB2 II V8 FP10 on AIX 5.2

I am trying to have DB2 II connect to Teradata and in the process getting the following error (create wrapper, create server, create user mapping are all completed):

SET PASSTHRU PAPROD
DB20000I The SQL command completed successfully.

SELECT COUNT(*) FROM DBC.TABLES
SQL1822N Unexpected error code "303" received from data source "PAPROD".
Associated text and tokens are "CLI2: BADLOGON(303): Invalid logon string.".
SQLSTATE=560BD

SET PASSTHRU RESET
DB20000I The SQL command completed successfully.


I can do the same successfully through BTEQ utility though using the same username and password:

BTEQ -- Enter your DBC/SQL request or BTEQ command:
select count(*) from dbc.tables;

select count(*) from dbc.tables;

*** Query completed. One row found. One column returned.
*** Total elapsed time was 2 seconds.

Count(*)
-----------
8512

Any idea, what could be wrong?

Thanks. Paul
Reply With Quote
  #2 (permalink)  
Old 10-17-05, 11:37
przytula przytula is offline
Registered User
 
Join Date: Nov 2004
Posts: 374
ii

have you also tried - create nickname ...
see what is returns
must be with a connection string setting to terradata
finally take a db2 trace and see how this is supplied to target
__________________
Best Regards, Guy Przytula
DB2/ORA/SQL Services
DB2 DBA & Advanced DBA Certified
DB2 Dprop Certified
http://users.skynet.be/przytula/dbss.html
Reply With Quote
  #3 (permalink)  
Old 10-17-05, 11:59
dollar489 dollar489 is offline
Registered User
 
Join Date: Sep 2002
Posts: 456
I get the same error message when trying to create a nickname as well!
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On