I have installed db2 express c on redhat linux.I can able to start the database & I can able to do all the operations on db2.Now I m trying to connect to through IBM data studio , I m getting the below error.
com.ibm.db2.jcc.am.DisconnectNonTransientConnectio nException: [jcc][t4][11
550][3.61.86] Exception java.net.ConnectException: Error opening socket to server /192.168.61.140 on port 50,000 with message: Connection timed out: connect. ERRORCODE=-4499, SQLSTATE=08001
I m a learner in linux activities. So I request you to kindly help me
If it is a modern version of RHEL be sure to open the relevant ports for the db2 instance(s) with the tool called
system-config-firewall or equivalent command-line methods.
Otherwise other environments (such as windows laptops etc running the Data Studio ) will be unable to connect to DB2.
Additionally if there are other firewalls between the RHEL lpar and the hostname running DataStudio then each firewall along the route needs the relevant port to be opened.
[ Separately, if you know how to use SSH tunnelling, the default port 22 is normally open and you can tunnel db2 traffic over the SSH port which works well - although you need to RTFM carefully to set it up properly - that is an SSH matter and not a DB2 matter]