Encountering an issue when attempting to establish a connection with a remote DB2 database, resulting in the following exception:
SQL30081N A communication error has been detected.
The communication protocol in use is 'TCP/IP'. The communication API being utilized is 'SOCKETS'. Error detected at location "192.168.1.200'. Function causing the error is 'SelectForConnectTimeout'. Specific protocol error code: '0'. SQLSTATE=08001.
Utilizing the below connection string:
let conn= await ibmdb.open("Driver={IBM DB2 ODBC DRIVER - DB2V11};DATABASE=DBInstance;UID=username;PWD=password;HOSTNAME=hostname;port=446;");
result = await conn.query(sql_Query);