I am having issues connecting to a DB2 database using toad on windows.
I have no problems connect via cmd using the Data server client.
I’m currently on the network so I do not believe there would be an issue with the firewall.
C:\Users\wwww>db2 attach to user
Enter current password for xxxxxx:
Instance Attachment Information
Instance server = DB2/AIX64 10.5.0
Authorization ID = xxxxxxx
Local instance alias = yyyyyy
C:\Users\wwwwww>db2 connect to zzzzzz user xxxxx
Enter current password for xxxxxx:
Database Connection Information
Database server = DB2/AIX64 10.5.0
SQL authorization ID = xxxxx
Local database alias = zzzzzz
When connecting via toad this is the error I get using the same driver:
ERROR [08001] [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: “198.181.142.120”. Communication function detecting the error: “connect”. Protocol specific error code(s): “10013”, “", "”. SQLSTATE=08001
Any help would be much appreciated.