Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2007
    Posts
    72

    Unanswered: SQL1336N and DB2 CONNECTIVITY PROBLEM. What am I doing wrong?

    Hi all,

    I am having a DB2 connectivity problem that I hope someone can help me resolve. I need this to test Replication and such other things. What am I doing wrong here? Any help that
    I can get will be highly appreciated.

    First, the error that I am getting when I try to connect to the remote host after performing NODE and database catalog is the following:

    [IBM][CLI Driver] SQL1336N The remote host "WINSVR2008R2-2" was not found. SQLSTATE=08001. I have reviewed the associated explanation for the SQL1336N error message which in
    essence states that the system cannot resolve the IP address of the remote host.

    For further clarification, I have DB2 Express-C 9.7 installed on my Vista Home premium Laptop. I also have VMware Workstation 6.5.3 hosting Windows Server 2008 R2 as guest OS.
    On this Windows Server 2008 R2 is installed a copy of DB2 Express-C 9.7. I desire connectivity to this DB2 copy from my Vista machine's DB2 Control Center. Below is what I have
    configured for my local and remote DB2 environment.

    Please take note of what I have for IP address from issuing IPCONFIG for both VISTA host and the VMware Windows Server 2008R2:

    (1) From the Services file on both environment (Vista and Windows Server2008R2) I have:

    SERVICE NAME PORT#

    db2vistaj_DB2 55000/tcp #HomeLaptop-1 <---- Vista Home Premium - Local Machine
    db2vista_DB2 50000/tcp #HomeLaptop-1

    db2j_DB2T0 65000/tcp #Windows Server 2008 R2 TestBaseVM <---- VMware/Windows Server 2008 R2 (Remote). Cataloged locally
    db2c_DB2T0 60000/tcp #Windows Server 2008 R2 TestBaseVM

    db2j_DB2W0 55000/tcp #Windows Server 2008 R2 WorkBaseVM <---- Another VMware/Windows server 2008 R2. This is not currently cataloged on my local machine
    db2c_DB2W0 50000/tcp #Windows Server 2008 R2 WorkBaseVM local machine (Remote)



    Catalog Information:

    cATALOG TCPIP NODE SVR2008A REMOTE WINSVR2008R2-2 SERVER db2c_DB2T0 OSTYPE WIN

    CATALOG DATABASE SAMPLE AS SAMPLEA AT NODE SVR2008A


    db2 => list node directory

    Node Directory

    Number of entries in the directory = 1

    Node 1 entry:

    Node name = SVR2008A
    Comment =
    Directory entry type = LOCAL
    Protocol = TCPIP
    Hostname = WINSVR2008R2-2
    Service name = db2c_DB2T0

    db2 => list database directory

    System Database Directory

    Number of entries in the directory = 3

    Database 1 entry:

    Database alias = TOOLSDB
    Database name = TOOLSDB
    Local database directory = C:
    Database release level = d.00
    Comment =
    Directory entry type = Indirect
    Catalog database partition number = 0
    Alternate server hostname =
    Alternate server port number =

    Database 2 entry:

    Database alias = SAMPLEA
    Database name = SAMPLE
    Node name = SVR2008A
    Database release level = d.00
    Comment =
    Directory entry type = Remote
    Catalog database partition number = -1
    Alternate server hostname =
    Alternate server port number =

    Database 3 entry:

    Database alias = SAMPLE
    Database name = SAMPLE
    Local database directory = C:
    Database release level = d.00
    Comment =
    Directory entry type = Indirect
    Catalog database partition number = 0
    Alternate server hostname =
    Alternate server port number =

    ------------------------------------------------------------------------------------------------------------------------------------------------------

    IPCONFIG -- WINDOWS SERVER 2008 R2

    C:\Users\Administrator>ipconfig /all

    Windows IP Configuration

    Host Name . . . . . . . . . . . . : WINSVR2008R2-2
    Primary Dns Suffix . . . . . . . :
    Node Type . . . . . . . . . . . . : Hybrid
    IP Routing Enabled. . . . . . . . : No
    WINS Proxy Enabled. . . . . . . . : No

    Ethernet adapter Local Area Connection* 9:

    Media State . . . . . . . . . . . : Media disconnected
    Connection-specific DNS Suffix . :
    Description . . . . . . . . . . . : Microsoft Failover Cluster Virtual Adapte
    r
    Physical Address. . . . . . . . . : 02-0C-29-6E-50-FB
    DHCP Enabled. . . . . . . . . . . : Yes
    Autoconfiguration Enabled . . . . : Yes

    Ethernet adapter Local Area Connection:

    Connection-specific DNS Suffix . :
    Description . . . . . . . . . . . : Intel(R) PRO/1000 MT Network Connection
    Physical Address. . . . . . . . . : 00-0C-29-EF-CE-93
    DHCP Enabled. . . . . . . . . . . : No
    Autoconfiguration Enabled . . . . : Yes
    Link-local IPv6 Address . . . . . : fe80::fc5c:9725:716c:6c50%11(Preferred)
    IPv4 Address. . . . . . . . . . . : 192.168.2.2(Preferred)
    Subnet Mask . . . . . . . . . . . : 255.255.255.0
    Default Gateway . . . . . . . . . : 192.168.2.1
    DHCPv6 IAID . . . . . . . . . . . : 234884137
    DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-12-6D-E2-CA-00-0C-29-6E-50-FB

    DNS Servers . . . . . . . . . . . : 192.168.2.1
    NetBIOS over Tcpip. . . . . . . . : Enabled




    IPCONFIG -- VISTA (HOST and Showing, Wireless Network Connection, VMware Network Adapter VMnet1 and VMnet8)

    C:\Users>IPCONFIG /ALL

    Windows IP Configuration

    Host Name . . . . . . . . . . . . : HomeLaptop-1
    Primary Dns Suffix . . . . . . . :
    Node Type . . . . . . . . . . . . : Hybrid
    IP Routing Enabled. . . . . . . . : No
    WINS Proxy Enabled. . . . . . . . : No
    DNS Suffix Search List. . . . . . : Belkin

    Wireless LAN adapter Wireless Network Connection:

    Connection-specific DNS Suffix . : Belkin
    Description . . . . . . . . . . . : Atheros AR5007 802.11b/g WiFi Adapter
    Physical Address. . . . . . . . . : 00-23-4D-B5-17-89
    DHCP Enabled. . . . . . . . . . . : Yes
    Autoconfiguration Enabled . . . . : Yes
    Link-local IPv6 Address . . . . . : fe80::54a1:eaaf:3842:591c%11(Preferred)
    IPv4 Address. . . . . . . . . . . : 192.168.2.2(Preferred)
    Subnet Mask . . . . . . . . . . . : 255.255.255.0
    Lease Obtained. . . . . . . . . . : Wednesday, October 21, 2009 9:35:53 PM
    Lease Expires . . . . . . . . . . : Friday, October 19, 2018 9:35:53 PM
    Default Gateway . . . . . . . . . : 192.168.2.1
    DHCP Server . . . . . . . . . . . : 192.168.2.1
    DHCPv6 IAID . . . . . . . . . . . : 234890061
    DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-12-62-44-FB-00-23-4D-B5-17-89

    DNS Servers . . . . . . . . . . . : 192.168.2.1
    192.168.2.1
    NetBIOS over Tcpip. . . . . . . . : Enabled

    Ethernet adapter Local Area Connection:

    Media State . . . . . . . . . . . : Media disconnected
    Connection-specific DNS Suffix . :
    Description . . . . . . . . . . . : Realtek RTL8102E Family PCI-E Fast Ethern
    et NIC (NDIS 6.0)
    Physical Address. . . . . . . . . : 00-1E-EC-B7-40-15
    DHCP Enabled. . . . . . . . . . . : No
    Autoconfiguration Enabled . . . . : Yes

    Ethernet adapter VMware Network Adapter VMnet1:

    Connection-specific DNS Suffix . :
    Description . . . . . . . . . . . : VMware Virtual Ethernet Adapter for VMnet
    1
    Physical Address. . . . . . . . . : 00-50-56-C0-00-01
    DHCP Enabled. . . . . . . . . . . : No
    Autoconfiguration Enabled . . . . : Yes
    Link-local IPv6 Address . . . . . : fe80::71e1:6dac:8abe:3e46%12(Preferred)
    IPv4 Address. . . . . . . . . . . : 192.168.233.1(Preferred)
    Subnet Mask . . . . . . . . . . . : 255.255.255.0
    Default Gateway . . . . . . . . . :
    DHCPv6 IAID . . . . . . . . . . . : 369119318
    DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-12-62-44-FB-00-23-4D-B5-17-89

    DNS Servers . . . . . . . . . . . : fec0:0:0:ffff::1%1
    fec0:0:0:ffff::2%1
    fec0:0:0:ffff::3%1
    NetBIOS over Tcpip. . . . . . . . : Enabled

    Ethernet adapter VMware Network Adapter VMnet8:

    Connection-specific DNS Suffix . :
    Description . . . . . . . . . . . : VMware Virtual Ethernet Adapter for VMnet
    8
    Physical Address. . . . . . . . . : 00-50-56-C0-00-08
    DHCP Enabled. . . . . . . . . . . : No
    Autoconfiguration Enabled . . . . : Yes
    Link-local IPv6 Address . . . . . : fe80::35cc:4e5d:6032:35dd%13(Preferred)
    IPv4 Address. . . . . . . . . . . : 192.168.139.1(Preferred)
    Subnet Mask . . . . . . . . . . . : 255.255.255.0
    Default Gateway . . . . . . . . . :
    DHCPv6 IAID . . . . . . . . . . . : 402673750
    DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-12-62-44-FB-00-23-4D-B5-17-89

    DNS Servers . . . . . . . . . . . : fec0:0:0:ffff::1%1
    fec0:0:0:ffff::2%1
    fec0:0:0:ffff::3%1
    NetBIOS over Tcpip. . . . . . . . : Enabled

  2. #2
    Join Date
    Oct 2007
    Posts
    246
    try this catalog info

    CATALOG TCPIP NODE NODENAME REMOTE IPADDRESS SERVER PORTNUMBER REMOTE_INSTANCE INSTANCENAME SYSTEM HOSTNAME OSTYPE AIX

    CATALOG DATABASE DBNAME AS DBALIASNAME AT NODE NODENAME

Posting Permissions

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