467,199 Members | 987 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,199 developers. It's quick & easy.

How can i Connet from 1 DB2 Server/Client to Remote Server on AIX

HI,

This is the present situation.

1.I have Db2 9.1 installed on 1 AIX machines(server).I have database
created and everything is runniing.

2.I have another server with db2 9.1 and I want to connect from this
machine to above machine.,

I dont have Db2 client avaiable in this box.

Can any one Please let me know what could be optimum solution for
this.

I tried this example and is not working.

Main thing i should be able to login from 1 machien to other machine

db2 catalog tcpip4 node db2tcp2 remote 192.0.32.67 server db2inst1
with "Look up IPv4 address from 192.0.32.67"

Aug 4 '07 #1
  • viewed: 3322
Share:
1 Reply
"koole" <Ke**************@gmail.comwrote in message
news:11**********************@19g2000hsx.googlegro ups.com...
HI,

This is the present situation.

1.I have Db2 9.1 installed on 1 AIX machines(server).I have database
created and everything is runniing.

2.I have another server with db2 9.1 and I want to connect from this
machine to above machine.,

I dont have Db2 client avaiable in this box.

Can any one Please let me know what could be optimum solution for
this.

I tried this example and is not working.

Main thing i should be able to login from 1 machien to other machine

db2 catalog tcpip4 node db2tcp2 remote 192.0.32.67 server db2inst1
with "Look up IPv4 address from 192.0.32.67"
The client is included with the server code. You need to first catalog the
remote tcpip node, and then catalog the remote database.

In your catalog node statement, db2inst1 should be the port number of the
instance, not the instance name (unless you have the port defined in
/etc/services with a service name of db2inst1). The default port is 50000,
so you might want to try that. Also, it should be tcpip, not tcpip4.

db2 catalog tcpip node db2tcp2 remote 192.0.32.67 server 50000

Then catalog the database.

db2 catalog db sample as sample2 at node db2tcp2 authentication server

then

db2 connect to sample2

In the above example db2tcp2 can be anything you want so long it is
consistent between the 2 catalog statements and unique on that client.
Sample2 can be anything so long it is unique on that client (as a local db
or remote database alias). I used sample2 since you may already have a
sample database locally defined on your "client" db server.

Aug 4 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Oliver Klozoff | last post: by
7 posts views Thread by Ken Allen | last post: by
1 post views Thread by Syed Naveed Ausaf | last post: by
reply views Thread by Suresh | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.