Client For DB2

[swaroopa]

HI All
I have installed DB2 9.7 in my remote desktop on windows ..I am breaking my head to get the client which can talk to it.can some one please provide me the appropriate link ..Please guys help me out

[Rabbit]

Didn't it install the DB2 control center?

[swaroopa]

I can access Db2 in its local system by control center but how can i access it from remote desktop.

[vijay2082]

Hi,

Install the db2 clinet on the remote machine , catalog the database and you are ready to access it.

You can download DB2 server client from below link.
https://www-304.ibm.com/support/docv...id=swg24029745

Cheers, Vijay

[swaroopa]

HI Vijay,
Thanks for the reply but i did not understand what you said exatly

Think that I have 2 machines A and B
I have installed DB2 on A and here i can access DB2 by using control center but how can i access from machine B

[Rabbit]

Install the control center on B. Find out what port A is listening on and access it using the ip and port. If you're on the same LAN, that's all you need. If you're trying to access it from outside of that, you may need to forward the port.

[vijay2082]

Swarrop,

Let me see if I can clear by below example.

System A: you have installed db2 udb v9.7 and created a database

System B: You want to access the database created on System A.

There are various ways to accesss the database from System B.

1) Install the db2 admin client on system B and use configuration assistant to catalog your database locally to the system on system B. For that you must have db2 admin server installed on System A.

2) If you don;t have DAS installed on the system A then install the db2 run time client from my earlier post, and use below link to catalog the database.

http://publib.boulder.ibm.com/infoce.../r0001936.html

3) You can also use MSTSC from SYSTEM B to remote login into the SYSTEM A and access the database.

4) There are otehr options too but they require advance concepts know how and I will advise you to learn more to get yourself familarize with the DB2 UDB.
Still if you face issues then look for more information in the DB2 V9.7 information centre or ask for help from a DBA known to you who can walk you through some basics and help you understand the basic connectivity options in db2 udb.