Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2005
    Posts
    2

    Exclamation Unanswered: DB2 Connect Error

    [FONT=Book Antiqua]I have installed DB2 Connect 7.2.5 . I am connecting to Server running in MVS OS 390 . i am connecting the server which is in different network .
    i am connecting the server through a Firewall host name and port number .

    I am successfully able to connect to the Database using DB2 Command Centre. But when I install some applications and try to fetch data from database it is throwing me following weird error.

    SQL error. Stmt #: 2367 Error Position: 0 Return: 8200 - [IBM][CLI Driver][DB2] SQL30020N Execution failed because of a Distributed Protocol Error that will affect the successful execution of subsequent commands and SQL statements: Reason Code "124C-15". SQLSTATE=58009.

    Please some one help me

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    drda

    as the drda message indicates : some protocol error
    according the message : check sqlca - and trace file might be needed..
    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
    Nov 2005
    Posts
    2

    DB2 Connect Error

    Thanks for your reply.

    I checked the CA . Will you please let me know how to take the trace files . Bcz this is quite urgent ..

    Will you please give your contact number . I can reach you on Monday .. Thanks .

  4. #4
    Join Date
    Nov 2004
    Posts
    374

    drda

    db2drdat on -t /path/filename
    produce error
    db2drdat off
    I can look at the trace, but don't have access to all db2 code, so I might not know, what is the meaning of a specific error.
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

Posting Permissions

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