Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002
    Posts
    456

    Unanswered: 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

  2. #2
    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

  3. #3
    Join Date
    Sep 2002
    Posts
    456
    I get the same error message when trying to create a nickname as well!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •