If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > confirue db2 server from client issue

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-04-05, 10:38
mohd mohd is offline
Registered User
 
Join Date: Jul 2003
Posts: 63
Question confirue db2 server from client issue

Hi,
I am trying to add remote server ( on solaris) to control center (on win2000) and getting this 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: "". Communication function detecting the
error: "gethostbyname". Protocol specific error code(s): "*", "11004",
"*". SQLSTATE=08001

quick response is appreciated.
__________________
Mohd
Reply With Quote
  #2 (permalink)  
Old 01-04-05, 11:44
chavadb2 chavadb2 is offline
Registered User
 
Join Date: Aug 2004
Posts: 138
check if registry variable DB2COMM is set to tcpip at server. ifnot, set it to tcpip
Reply With Quote
  #3 (permalink)  
Old 01-04-05, 11:56
mohd mohd is offline
Registered User
 
Join Date: Jul 2003
Posts: 63
Hi,

DB2COMM is set to TCPIP and also
sevice port and interrupt port are are set in services file correcty at server and also at client.

DB2 version is 8.1
I am able to connect to remote database using command line but not able to add it to control center.
__________________
Mohd
Reply With Quote
  #4 (permalink)  
Old 01-04-05, 12:41
przytula przytula is offline
Registered User
 
Join Date: Nov 2004
Posts: 374
client connect

probably you have used as system name (in cc) a name that is not known
it should be
- the ip address of target server
- known hostname
- entry in hosts file in client station pointing to ip of target server
This should do (I hope)
Best Regards, Guy Przytula
__________________
Best Regards, Guy Przytula
DB2/ORA/SQL Services
DB2 DBA & Advanced DBA Certified
DB2 Dprop Certified
http://users.skynet.be/przytula/dbss.html
Reply With Quote
  #5 (permalink)  
Old 01-04-05, 16:41
mohd mohd is offline
Registered User
 
Join Date: Jul 2003
Posts: 63
Hi,

I am using the correct hostname.
but when i enter the system name it is not taking full name as there is limit on the field size for system name field.

and when i give ip address in place of system name it is giving that error.

do we need to have entry in the host file for the target server?
I was able to configure database using configuration assistant but still getting error while adding node thru control center.

ur help is appreciated.
__________________
Mohd
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On