Results 1 to 8 of 8
  1. #1
    Join Date
    Sep 2006
    Posts
    105

    Unanswered: DB2 Connectivity Issue

    Hello All,

    We have a DB2 Connect Server - with DB2V8.1 FP18 and OS level as AIX 5.2.
    From Application Client Interface , they are getting the connectivity error as below:

    [IBM][CLI Driver] SQL30061N The database alias or database name "DB2D " was not found at the remote node. SQLSTATE=08004
    [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

    Am able to connect to the db from my end.

    Please advise what may be the cause of this issue and how to eradicate the same ?

    Thanks
    Meena.s

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    is db2 connect installed at gateway server or same server as client
    check db2 list node directory - db directory from gateway and client
    check that port -svcename is cataloged correctly
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Sep 2006
    Posts
    105
    All the Basic checks were done like svcename , node details etc.
    Also db2 connect installed at gateway server only.

    Thanks
    Meena.s

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    is it a general problem or just for 1 user ?
    trying to eliminate reasons for the problem if not more details are published..
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  5. #5
    Join Date
    Sep 2006
    Posts
    105
    Its a developement application , so initially testing with single user id.
    But the user id they use - is common at the application client interface.

  6. #6
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    so where is the client application interface running - same or other machine
    try todo the connect from command line in that machine and see detailed msg
    why is db2 connect involved ? is it a connect to mainframe
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  7. #7
    Join Date
    Sep 2006
    Posts
    105
    Application interface is running on other machine , and as you said its a connect to mainframe.
    we tried connecting to the db from command line in that machine , same error which I pasted above.

    Thanks for your help.

    Regards
    Meena.s

  8. #8
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    when you cataloged the dcs db - probably you mixed the source and target name
    check syntax
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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