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