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

Ports for DB2 behind firewall / ssh port forward

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


P: n/a
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:remotename:50000 -L
50001:remotename: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 discussion thread is closed

Replies have been disabled for this discussion.