I want to use the CLP with SSH as the execution method in the SQL screen of IBM Data Management Console (IDMC), rather than JDBC.

If the server running DB2 is using an SSH port other than 22,

how can I connect to that server via SSH in IDMC?

I cannot find the screen for configuring the SSH port.

Is there a way to set a port other than 22?

Thank you.

Hello JH,

Usually the SSH configuration is in the ssh_config file, not in DMC.

Here is a link that might help you:

https://www.ibm.com/docs/en/db2-data-mgr-console/3.1.x?topic=securing-communicating-securely-remote-servers

I hope that helps!

Hello JH,

Please create a case with IBM DMC Support team, so we can confirm with our extended team if there is a way to change that port internally or if the port number is coded in DMC code.

Original Message:
Sent: Mon February 19, 2024 10:32 AM
From: JH Kim
Subject: [IDMC] remote ssh port setting in idmc

Thank you for your response. 

I have some additional questions

 

Due to policy constraints, we cannot change the SSH port for the DB2 server. 

The server information is as follows:

* db2 server info 

- ip : 192.168.1.70

- ssh port : 2022

 

To connect to the server via SSH, the SSH configuration on the idmc server has been set as follows:

cat ~/.ssh/config

Host 192.168.1.70

hostname 192.168.1.70

user db2inst1

port 2022

 

SSH connection to db2inst1@192.168.1.70 from the idmc server is successful.

 

However, when testing the CLP with SSH from the idmc server as shown below, an error occurs. 

The log file 'runsql.0' on the idmc server is as follows:

CLPRunner::connectToDifferentHost: IOException in run() of DB2CLPRunner. -- Exception is: Failed to connect to SSH server 192.168.1.70 with username db2inst1.

 

It seems that the issue is arising from attempting to connect to the server on port 22. 

If changing the DB2 server's SSH port to 22 is not possible, 

does this mean that CLP with SSH cannot be used from the idmc server?

------------------------------
JH Kim
------------------------------


Original Message:
Sent: Mon February 19, 2024 09:10 AM
From: Cintia Ogura
Subject: [IDMC] remote ssh port setting in idmc

Hello JH,

Usually the SSH configuration is in the ssh_config file, not in DMC.

Here is a link that might help you:

https://www.ibm.com/docs/en/db2-data-mgr-console/3.1.x?topic=securing-communicating-securely-remote-servers

I hope that helps!

------------------------------
Cintia Ogura