Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2014
    Posts
    1

    Unanswered: ODBC configuration for a remote DB2

    Hello,
    I am trying to connect to a remote DB2 server hosted on a OS/390 box , from my windows 7 machine.
    I tried cataloging the tcpip node and the database from the command line processor ( I have DB2 Connect installed on my windows system ) .
    When I try to connect to the database using the db2 connect command I get the below error .

    SQL30081N A communication error has been detected. Communication protocol
    being used: "TCP/IP". Communication API being used: "SOCKETS". Location
    where the error was detected: "9.63.66.46". Communication function detecting
    the error: "connect". Protocol specific error code(s): "10061", "*", "*".
    SQLSTATE=08001


    I get the same error when I try to connect from my windows ODBC connection .

    Here are the details I am given with to configure the connection

    DB2SYSTEM= hostnamexx.in.xx.com
    Instance=DB2
    ServerType=DB2MVS
    Nodetype=U
    Protocol=TCPIP
    Hostname=hostnamexx.in.xx.com
    Portnumber=5010
    Security=0

    [DB>NDE4E458P2H]
    Dir_entry_type=DCS
    Authentication=SERVER
    DBName=DCS4FAF6
    TargetDatabase=USIBMVRDP2H

    [CLI_ODBC>DP2H]
    DataSourceName=DP2H
    DataSourceType=System
    DBALIAS=DP2H
    ODBCParameters=No

    I am new to DB2 and would appreciate any help in getting this set up successfully .

    Thanks

  2. #2
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Did you see my earlier thread? http://www.dbforums.com/db2/1701877-...mainframe.html
    Please try my examples. They work fine.
    Somewhere between " too small" and " too large" lies the size that is just right.
    - Scott Hayes

Posting Permissions

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