Unanswered: connect IBM Control Center to remote dB
Im using the Config assistant to connect a client to a remote server, when finished i get the error below, any ideas?
I have run the 'CATALOG' cmds on the client e.g.
db2 catalog tcpip node db2 remote 18.104.22.168 server 22
db2 catalog database DBNAME as DBNAME at node db2
db2 CATALOG DCS DATABASE DBNAME
and can see the port is listening in netstat -a | more e.g.
tcp 0 0 *:xcmccarth *:* LISTEN
I haven't configured anything on the server side as dont have permissions, do I need to? but in the /etc/services file i can see the remote connection port is 446 which is the same as i config on the client,
SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "22.214.171.124". Communication function detecting the error: "connect". Protocol specific error code(s): "10061", "*", "*". SQLSTATE=08001
When you catalog the node on the client workstation, you need to supply the port for the DB2 instance on the server. This normally defaults to 50000. Run "db2 get dbm cfg" on the server as the instance an look for SVCENAME. This will either be the port name or the name in /etc/services.