Toad World® Forums

How to connect TOAD for DB2 database

Dear All,

I’ve installed the “Toad for DB2 Freeware 4.6”. Now I need to connect the DB2 database.
So when I select File -> New -> connection then it shows the welcome to the client configuration wizard with add catalog entry etc.

  1. clicked add catalog entry
  2. operation system - windows, hostname - , port - 60001 and clicked next

Now I am confused what to give as Node name, instance name

Can anyone please mention the detail steps for this DB2 connection.

connection details as below

Driver :- com.ibm.db2.jcc.DB2Driver
host -
port - 60001
database name :- EM3SICOR
username :-
password :-
Connection String:- jdbc:db2://:60001/:user=;password=;

Regards
Arihan
Message was edited by: arihanMessage was edited by: arihan

Message was edited by: arihan

Node Name: Any symbols
Instance name:
You can query it from here (by default: DB2): SELECT INST_NAME FROM TABLE(SYSPROC.ENV_GET_INST_INFO()) AS SYSTEMINFO

http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp

Hi,
I recon you to remove few details from your original description.
example:- username, password, connection string,etc.,
Regards

null

I am getting the error as

Command execution fails. Unable to route command to DB2 CLP Process.
Failed to connect to an IPC Port: The system cannot find the file specified.

Command execution fails. Unable to route command to DB2 CLP Process.
Failed to connect to an IPC Port: The system cannot find the file specified.

Hi,
Might be useful for everyone.

First check which operating system do you have and check where it has installed TOAD DB2.

If you are using Window 7 64bit then it will be defaulted to install at C:\Program Files(x86)… which might cause the problem.

Either you have to intall TOAD DB2 at C:\Program Files… or point to the dafaulted.

Give a try.

Regards