Toad World® Forums

how to provide all the parameters in order to connect to DB2

Hello all, I am new to DB2 and Toad, I have Toad Free Version 4.6.2.573, DB2 v9.5.0.0, “AIX6495”, and Fix Pack “0”.

I can login to db2 through putty, I dont’ know what values I should provide in Toad when connect:

Database Alias
Node Name
Authentication
Host Name (Should I use the name when I use putty to log in? When I use ifconfig in the box I get a different ip)
Instance name
TCP/IP port number
Enable SOCKS Security (Ture/False)

I have full access to db2, I just don’t know where I can get those values. Thanks for any suggestions!

btw, I do NOT want to touch anything for the existing DB, I just want to connect it using toad so that I can run SQL query against it. If there is other ways/software can achieve this it’s also okay.

Hi,

You can use the Client Configuration Wizard to create a new connection to a database. You’ll need the host name, port number, database name, user id and password. The same information you use for putty.

You can do this by opening the Connection Manager, then launch the connection wizard, catalog your database, then use the dropdown in the connection manager to connect to your database.

Regards,
Adam

Adam,

Thank you for your reply. When you say: catalog the database, what does that mean? What’s the effect for the DB, will that affect any existing application or performance for the DB?

Thanks,
Newbiec

Hi Newbiec,

Toad for DB2 installs a DB2 client from IBM. Cataloging a database provides the DB2 client with the information it needs to communicate with the database. It only effects the machine where Toad is installed.

Regards,
Adam

So if I have existing toad client for the same db, cataloging won’t affect those clients, right? I searched the web and there are two commands, which one should I use?

Catalog the DB2 server node
To catalog the DB2 server node, enter the following command:
db2 catalog tcpip node db2node remote hostname server service_name
where db2node is the name of the system where the DB2 client is installed (which must be unique in your node directory list), hostname is the fully qualified name of the system where the DB2 server is installed, and service_name is the connection port name as defined in the services file.
Catalog remote DB2 databases
To catalog a remote database, enter the following command:
db2 catalog database db_name as alias_name at node db2node
where db_name is the name of the remote database, alias_name is the name of the client instance, and db2node is the name of the system where the DB2 client is installed.

Thanks,
Newbiec

Hi Newbiec,

I’m not sure I understand precisely what you’re saying about other Toad clients. However, creating connections for one Toad installation shouldn’t effect the other installations. Actually, if you have other Toads for DB2 installed, Toad will detect the other catalogs and prompt you to migrate connections from earlier installations to the latest installation.

You shouldn’t have to issue any catalog commands to use Toad. The Client Configuration Wizard will prompt you for the required information, create and execute the catalog commands.

Regards,
Adam

Adam,

Thanks for your reply.

What should I use for the following parameters when use the wizard.
Node Name
Database Alias
TCP/IP Port number
Enable SOCKS Security?

I can give anything for the above parameters or I need to find it from db2 command?

Thanks,
Newbiec

Hi Newbiec,

Please contact me at adam.ririe@quest.com so we can work on your problem offline.

Thanks,
Adam

Problem solved! The main thing is my port number didn’t set up correctly, here is the info on how to find the correct port:
http://publib.boulder.ibm.com/infocenter/cmgmt/v8r3m0/index.jsp?topic=%2Fcom.ibm.sysadmin.hlp%2Fcsa10010.htm

Thank you so much Adam, you rock!

Hi,

Could you please tell how can I check the Port number and the node name.

On the database server display the DBM configuration values and get the SVCENAME via:

db2 get dbm cfg

Like:

TCP/IP Service name (SVCENAME) = db2c_DB2_02

Then look up that service name in the database server's etc/services file to identify the port number like:

db2c_DB2_02 50002/tcp

In the above 50002 is the port number.

Of course if Toad is connected to your database you can view the DB and DBM config values:

Hope this helps.