I am trying to add new connection in Control Center using "Add"
option. The host name "datt" and after search gets following
errror:

SQL30081N Wykryto b??d komunikacyjny. U?ywany protokó? komunikacyjny
"TCP/IP". U?ywany zestaw komunikacyjnych funkcji API: "SOCKETS".
Miejsce wykrycia b??du: "10.1.5.64". Funkcja komunikacyjna, która
wykry?a b??d: "recv". Kody b??dów w?a?ciwe dla protoko?u: "*", "*",
"0". SQLSTATE=08001


Can anybody suggested what is the problem and how to get it resolved... please let me know if you need any further info..

Thanks,
Raggs

SQL30081N is a communications error. You need to check your underlining TCPIP setup.

Andy

Hi,

Thanks for the reply .. can you tell me what need to be looked at the TCP/IP as I am new to DB2.. Also stack trace shows problem with the DB2.. so please let me know any ..

You need to supply more information. First what DB2 version and OS are you using? What is the tcpip address and configuration of the machine you are trying to add a connection on? Have you tried using the command line?

Andy

go to command window (db2cmd if windows)
db2 catalog tcpip node xxx remote ipaddress server portnumber
where xxx can be any name - ipaddress=ip of db2 server and port is port for instance of db2 server
db2 catalog db dbname at node xxx <<-- replace dbname with real db name
db2 connect to dbname user yyyy using ccc <<-- userid and password

this should work
if not return with errors encountered

The above problem occurs when there is a hostname in the network(two machines with same hostname). So, Discover component cannot resolve the ip address to the hostname. This results in an error window. Is this a probability of the problem... can any one suggest?

My suggestion would be to shoot the Network Administrator for allowing 2 computers to have the same name.

Instead of using the machine name, use the IP address.

Andy

wanted to know whether this is the probability for the error else any other such problems causes the above error? And also how is the command line different from the Control Center CA..?

Thanks for all of the suggestion

Having two computers with the same name is very probably the issue. How is the server going to resolve the name? One time it might get resolved as server a and another as server b. This will most positively cause problems.

The command line gives you better feedback, and you also have the ability to actually pick ALL of the options that are available for for the commands.

Andy

make an entry in etc/hosts directory

here you go press start+run type drivers
go to etc folder and open hosts file and make an entry