db2 connect to a db in a differrent server?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sohan - 14 Dec 2006 11:27 GMT

Hi,

One question - to connect to a db2 database in the same UNIX server we
can use from UNIX command prompt:

db2 connect to <dbname> USer <name> using <pwd>

Now if the db2 database is in a differrent server where/how do we
specify the server name or its ip address?

Thanks,
Sohan

Reply to this Message

m - 14 Dec 2006 11:42 GMT

> Hi,
>
[quoted text clipped - 8 lines]
> Thanks,
> Sohan

To connect to a remote server:

catalog tcpip node xxxxx remote yyy.yyy.yyy.yyy server zzzzz
xxxxx name
yyyy IP or DNS name
zzzz port

then

catalog db nnnnnn at node xxxxx

Then you can connect

Reply to this Message

sohan - 14 Dec 2006 13:29 GMT

Thanks for the response.

I am new to this. My understanding is that this cataloging has to be
done once by dba and then anybody can directly connect to database
using db2 connect. Is this correct?

> > Hi,
> >
[quoted text clipped - 21 lines]
>
> Then you can connect

Reply to this Message

Knut Stolze - 14 Dec 2006 13:36 GMT

> Thanks for the response.
>
> I am new to this. My understanding is that this cataloging has to be
> done once by dba and then anybody can directly connect to database
> using db2 connect. Is this correct?

Close... the SYSADM has to do the cataloging.

The cataloging creates entries in the nodes and database directories. All
DBs listed in the latter occur "as if they are local". The DB2 client will
then figure out if the DB is really local or indeed remote and takes care
of the communication with the respective DB2 server.

Signature

Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

Reply to this Message