Toad World® Forums

New connection to a DB2 database.

I need help I am new to the world of DB2, but I’m trying to make a new connection to the DB2 database we use.
The database is on a server and installed the Toad for DB2 on my laptop.

What do I need? … Just put the toad installed the server, port and also the database and does not connect me. send me the following error.

“”""""""“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: “”. Communication function detecting the error: “selectForConnectTimeout”. Protocol specific error code(s): “0”, “", "”. SQLSTATE=08001"”""""""

Maybe you have not cataloged the database correctly…or communicating from your client to your DB server is taking a long time.

What version of Toad for DB2 are you running?

You might try to open the IBM DB2 Command Line Processor (CLP) (From Start - All Programs) - for the DB2COPY that is used by Toad.

Then type:list database directory

That will indicate if you have any databases cataloged.

If you see the database then try connecting to that inside the CLP.

Via: connect to db user using password

If you think it is the correct IP address and DB information - run a ping or tracert to see if communication to the DB server is network bound