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