How to connect TOAD for DB2 database

Toad for IBM DB2
1

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

2

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

3

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

null

4

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.

5

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