By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,004 Members | 1,222 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,004 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
"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.