I recently had Toad4.2.7 installed. Have successfully connected and accessed a production db. In trying to connect and access another database, connection works, shows in list catalog and nodes but when I try to access with logon id and password (that others use), I get the following message.
ERROR  [IBM] SQL30081N A communication error has been detected. Communication protocol being used: “TCP/IP”. Communication API being used: “SOCKETS”. Location where the error was detected: “10.176.19.199”. Communication function detecting the error: “recv”. Protocol specific error code(s): “", "”, “0”. SQLSTATE=08001
I (and others) have verified that the catalog entries I’m using are correct. I have uncatalog and recataloged, verified that node and database exist using list commands. The interesting thing is if I ignore TOAD completely and only use native DB2 software to catalog, I can successfully access the database with the logon and password.
HELP & thanks in advance