"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.