469,266 Members | 2,028 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,266 developers. It's quick & easy.

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

25
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
Oct 22 '09 #1
0 3189

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

47 posts views Thread by Ivan Weiss | last post: by
5 posts views Thread by Scav | last post: by
reply views Thread by Pheasant Plucker® | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.