473,387 Members | 1,592 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

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
1 3510
"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Robert | last post by:
I get these errors when creating a asp .net web application project in VS 2003 on a remote web server: "Microsoft Development Environment The Web was created successfully, but an error occurred...
2
by: Oliver Klozoff | last post by:
Hi, I am having a hard time setting up an SQL Server 2000 Developer Edition instance for remote clients. The instance is running well and I can connect to it on the local computer. When I try...
4
by: Prince Kumar | last post by:
I joined a company recently and they have a java program which hangs (does nothing) after a while. This is no way consistent. It could succeed quite a few times and can fail a few other times....
7
by: Ken Allen | last post by:
I have a .net client/server application using remoting, and I cannot get the custom exception class to pass from the server to the client. The custom exception is derived from ApplicationException...
1
by: Syed Naveed Ausaf | last post by:
Hi all, My scenario is this: Central Server: on which a number of remote machines invoke services (implemented as web services, but doesn't matter what the choice of implementation is). ...
0
by: Maciek | last post by:
Hi When I set Session state mode to StateServer (IIS 6.0; windows2003; .NET 2.0) in my application, I have recived this message:...
9
by: RvGrah | last post by:
After much hair-pulling, I've finally found the answer to a problem that many are fighting with, difficulty connecting from Sql 2005 Server Management or VS2005 to a remote Sql Server running Sql...
0
by: Suresh | last post by:
Hi Guys I have Db2 server installed on remote server. i am connecting to that remote server by using VPN. I want to connect that remote DB2 server instance using my local machine DB2...
1
by: DR | last post by:
What ports do i need to unblock on client and server (running msvsmon.exe) to debug remotely from my client box with visual studio 2005 pro? When I attach to remote process a connection shows up...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.