Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2010

    Unanswered: Error when connecting to DB2 9.7.9 using CLI driver

    When i try to use the below command to testing the connection to DB2 9.7.9 server from application server with CLI driver, it will come out the below error message:

    1)command: db2cli validate -database pd1:sapdata:5912 -connect -user **** -passwd *****

    2)Error:Connection to : pd1:sapdata:5912
    [ibm][CLI Drive] SQL1042C An unexpected system error occurred. SQLSTATE=58004

    Connect Status: failure

    But if i copy the same CLI driver to another server to test to connect the database server, it can connect using the same command.
    It means the database server is available for connecting.

    So how can i troubleshoot this error due to i need this application sever to connect to the database server.
    Attached Thumbnails Attached Thumbnails CLI.jpg  

  2. #2
    Join Date
    Jul 2010
    Who can help me on this or need me to provide any other info.

  3. #3
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    Looking at the CLI trace might help.

    IBM Knowledge Center
    "It does not work" is not a valid problem statement.

Posting Permissions

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