Tried to connect from Toad to a local database and got error "SQL30081N Communication error has been detected".
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: "127.0.0.1". Communication function detecting the error: "connect". Protocol specific error code(s): "10061", "*", "*". SQLSTATE=08001
RESOLUTION 1:
Verify that the host name, port number, and database name entered into the Client Configuration Wizard are correct.
Host name Enter the TCP/IP address or the machine name for the server on which the DB2 database resides.
Port number Enter the port number for the server on which the DB2 database resides.
Database name Enter the real name of the DB2 database.
Database alias Enter a unique nickname to identify the database on your system. By default it will be the same as the Database name entered.
RESOLUTION 2:
Create a connection with host 127.0.0.1, LOOPBACK, port number 50000. Make sure database is up in order to connect. (db2start)
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center