Greetings to all.
When testing then connection to an IBM DB2 database in AEM, the following type of error is displayed:
Testing Data Source AS400 failed: ERROR [08001] [IBM] SQL30081N A communication error has been detected. Communication protocol being used: "TCP / IP". Communication API being used: "SOCKETS". Location where the error was detected: "10.77.200.21". Communication function detecting the error: “function”. Protocol specific error code (s): "rc1", "rc2", "rc3". SQLSTATE = 08001
The "function" parameter of the error message varies according to the port that is configured (for example, "selectForConnectTimeout" or "recv". Likewise, the Protocol specific error code(s) may also be different (for example "0", "*", "*" or "*", "*", "0").
This is the Data Source configuration screenshot:
The IBM DB2 database is located on a remote server, which is accessed through VPN (FortiClient).
Running the commands for network connectivity verification yields correct results (ping, telnet, netstat). I even installed on the same computer where the Appeon server is hosted, an IBM DB2 database management software (IBM Client Solutions) which successfully connects to the DB and allows queries to the database tables.
These are the screenshots of successful network connectivity tests:
Here, the screenshots of successful access to the database from within the administration console (IBM Client Solutions):
For all the above, I rule out this to be a problem of network communication, port restriction and/or firewall setting on the server side and that it is rather an error that originates in the IBM DB2 Driver itself used by the Appeon server.
PowerServer version:
Thanks in advance for any help!
It could definitely be verified that the problem with connecting to the IBM DB2 database was not from Appeon. It appears to be an incompatibility between the DB client and the server.
Thank you, Armeen and all for your generous and valuable collaboration.