View Single Post

   
  #4 (permalink)  
Old 02-27-2008, 01:06 PM
Jurgen Haan
 
Posts: n/a
Default Re: Newbie Connection question

Well, it seems that your server on 192.168.1.2 is not configure to talk
TCP/IP.

To check this, you can log in on the server, and execute a db2set.
if there's no line saying: DB2_COMM=TCPIP then you should probably add
this by using db2set.

Furthermore, if you do so, check in your /etc/services that there's an
entry like 'db2 50000/tcp'.
if not, add it. DB2 needs to know on what port to run its service.
And finally, check your DBM settings by executing a 'db2 get dbm cfg'
there should be a 'SVCENAME' please set this one to the corrosponding
setting in your services.

You can do this by, for example, executing:
'db2 UPDATE DBM CFG USING SVCENAME db2'

Now restart your instance (db2stop/db2start)

Good luck.

Steve Rainbird wrote:
>
> Then I tried to connect and got the following.
>
> $ db2 connect to pear
> SQL30081N A communication error has been detected. Communication protocol
> being used: "TCP/IP". Communication API being used: "SOCKETS". Location
> where the error was detected: "192.168.1.2". Communication function
> detecting
> the error: "connect". Protocol specific error code(s): "111", "*", "*".
> SQLSTATE=08001
> $
>
>
> Any ideas?

Reply With Quote