db2 connect to a db in a differrent server?

[sohan]

Hi,

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

db2 connect to <dbnameUSer <nameusing <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

[m]

sohan wrote:

Hi,

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

db2 connect to <dbnameUSer <nameusing <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

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

[sohan]

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?
m wrote:

sohan wrote:

Hi,

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

db2 connect to <dbnameUSer <nameusing <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

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

[Knut Stolze]

sohan wrote:

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.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany