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

koole

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

Subscribe Reply

3524

Mark A

"koole" <Ke************ **@gmail.comwro te in message
news:11******** **************@ 19g2000hsx.goog legroups.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

Similar topics

1761

trouble creating asp .net projects on remote server

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 when trying to configure the application root for this Web. Web projects may not operate correctly without an application root. The returned error was: Active Directory Services cannot find the web server. A possible cause for this is an...

ASP / Active Server Pages

10864

Setting up SQL Server for Remote Clients

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 connecting from another computer using Enterprise Manager with the server's IP as the instance name, I always get the usual "Specified SQL Server not found" error. I have used Enterprise Manager many times to connect to local and remote servers...

Microsoft SQL Server

6597

Client and Server process both seems to be sleeping forever

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. There is no consistency when it fails. Could anyone here shed some light on how to debug/resolve the issue. I guess IBM looked at the issue and were not able to pinpoint where the issue is. When the program hangs and when force the DB2...

DB2 Database

4756

Passing custom exceptions server to client

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 and is defined in an assembly common to the client and server components. The custom class merely defines three (3) constructors -- the null constructor; one with a string parameter; and one with a string and innner exception parameter -- that...

C# / C Sharp

1550

authentication between two server processes over the internet

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). Remote Servers: These are machine running at various sites worldwide. Each remote server would be on a separate network and separated from

ASP.NET

800

Unable to make the session state request to the session state server

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: ----------------------------------------------------------------------------------------------------------------- Unable to make the session state request to the session state server. Please ensure that the ASP.NET State service is started and that the client and server ports are the same. If the server is on a...

ASP.NET

2705

Fix of problem connecting VS2005 to remote Sql 2000 server

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 2000. In my case the server I couldn't reach was across a vpn connection, behind ISA server 2000, (which had port 1433 open). The answer was in this post:...

C# / C Sharp

3925

Connecting to Server Problem

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 development client. Bur Its gives me following error message. I searched lots of things on net and tried on remote server but i didnt got suceess. Can any one tell me how to set TCP\IP connection protocol on server for particular instance. Becuase I think

DB2 Database

2536

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?

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 in msvsmon.exe on the remote machine, however, the client box with visual studio displays error: "Unable to connect to the mricosoft visual studio remtoe debugging monitor named 'the box name' the micorosft visual studio remote debugging monitor...

C# / C Sharp

9686

What is ONU?

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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10250

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10222

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

10026

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

9068

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7564

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5463

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5585

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2938

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General