473,657 Members | 2,716 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Ports for DB2 behind firewall / ssh port forward

hi newsgroup,

I'd like to connect to a remote DB2 Database V 8.2 using the "DB2
Steuerzentrale" (I guess it's called something like "DB2 management console"
in the English version). Since the database host is behind a firewall I
tried to communicate through ssh port forwarding.

Therefore, I run:
ssh -L 6789:remotename :6789 -L 50000:remotenam e:50000 -L
50001:remotenam e:50001 -L 523:remotename: 523 remotename

Though the ssh connection is established, my "DB2 Steuerzentrale" won't
connect to localhost successfully and shows an error number SQL4404N.

Am I missing some ports? Thanks in advance.

Best,
Ina

Nov 12 '05 #1
1 4331
Hi Ina,

Ina Schmitz schrieb:
I'd like to connect to a remote DB2 Database V 8.2 using the "DB2
Steuerzentrale" (I guess it's called something like "DB2 management console"
DB2 Control Center. ;-)
Therefore, I run:
ssh -L 6789:remotename :6789 -L 50000:remotenam e:50000 -L
50001:remotenam e:50001 -L 523:remotename: 523 remotename
I have not tried it yet but at least the syntax looks good. ;-)
Though the ssh connection is established, my "DB2 Steuerzentrale" won't
connect to localhost successfully and shows an error number SQL4404N.

Am I missing some ports? Thanks in advance.


I don't think it is a matter of ports, but I believe, db2cc needs a
local instance (s.a. db2icrt).

Maybee you could try a workarround. Have you ever tried vnc?
vncserver is available for both unix and windoze systems and would allow
to run the control center on the remote instead of your local machine.

There are standalone-clients and it offers a java-applet as well.

Not the fastest approach but you would only need to forward one port.
You would need to look at the vnc-documentation to find out which one.

There are some free implementations of vnc out there:

http://freshmeat.net/search/?q=VNC&s...&Go.x=0&Go.y=0

I would try

http://www.tightvnc.com

as the project claims to be optimized for low bandwith

Best regards,

Norbert

Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
2171
by: Alexandr Molochnikov | last post by:
Hello group, I am trying to cut down the number of ports that must be opened in a firewall to let the client talk to the protected server. The server runs its own registry process by calling LocateRegistry.createRegistry(port), and the same port is used when UnicastRemoteObjects are exported. This way, I can tell the firewall admin to open only one hole in the firewall, instead of two. It all works, until I attempt to use a custom...
0
469
by: Cliff | last post by:
I need to get a list of "Open"/In-Use TCP Ports (actually to see if there is a cponnection with a destination Port of 21) I think what I'm after is similar to the output of netstat. I could run netstat and parse the output, but I'd prefer not to as I'm going to be doing this in a service and it needs to monitor the ports every few seconds. Any advice on how I can do it.
10
1764
by: John | last post by:
Hi I am using ms internet control in my app. It works fine form all machines except from a new one which has win xp sp2 installed. All machines are part of a small business server 2003 domain so have the isa server firewall client as well. Unfortunately I can't find a way to disable xp firewall once it is connected to the domain. How do I get past the xp firewall for internet control to work? Thanks
4
2405
by: Sean | last post by:
Hi, I'm programming an IRC bot. I'm trying to establish a dcc connection with another IRC client. I give the ipaddress and port number to the client in the request. I listen to that port with TcpListener on IPAddress.Any. The listener never receives a connection. My situation is the bot computer is behind a router. Is there something special that must be done to bind to the router's port? Thanks,
10
1643
by: Shaniqua Jones | last post by:
I've designed a C# application consisting of two EXEs: a client and server. The server runs on my Win2000 Server box, and the client runs on my customers' machines -- typically XP. The client app connects to the server, makes a request, and awaits a response. The server sends back the response at which point the client disconnects. The connection takes place on port 20198 (TCP). My server app was coded in such a way that only 10...
0
27031
by: nezoat | last post by:
Here is some working code to open the specified TCP port on the gateway nat device or firewall, and forward it to the calling machine. Great for p2p apps. The newsgroups are such a great resource and have helped me so much, I hope this helps others. Let me know if you find it useful! Lee Carlson Lee (at) Carlson (dot) net -----------------------------------
3
3077
by: Luke Davis | last post by:
I'm looking for an effective way to open and close TCP ports. Can I do this through Tcpclient? And I know this is a potential security risk, so what kind of permission must the person running the application possess to handle it without errors? -- Luke Davis, MCSE: Security DEM Networks - Senior Systems Architect 7225 N First, Suite 105 Fresno, CA 93720
1
4861
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...
2
29553
by: buddhika1984 | last post by:
Hi, I am going to make WMI connection to a remote computer. here, i want to know which ports should be opened in windows firewall (Windows server 2008) to do that. I tested with two machines by opening two ports (rather than creating rules). For a successful WMI connection, I had to open following ports. First machine: TCP 135, TCP 49154 Second machine: TCP 135, TCP 1027 1. That means for incoming WMI connections, Does it use 135...
0
8385
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, 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...
0
8821
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8723
jinu1996
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...
0
8602
tracyyun
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...
0
7316
agi2029
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...
1
6162
isladogs
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...
0
5632
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4300
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
1941
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.