1. Miguel Alzate
  2. PowerServer 2020 or older (Obsolete)
  3. Tuesday, 5 May 2020 15:08 PM UTC

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!

 

Accepted Answer
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Saturday, 9 May 2020 16:38 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # Permalink

VPN is not a reliable connection and it is slow.  You absolutely should not be using a VPN connection between your Web server and your database, at least for a real-life deployment.  

Comment
  1. Miguel Alzate
  2. Wednesday, 13 May 2020 00:30 AM UTC
Using newer version is customer's concern. So far, I'm in customer's hands as to know and test if DB2 client 9.7 (officially suported by Appeon) runs fine with IBM server 7.2. Well, I'll keep on seeing the goings of this issue.
  1. Helpful
  1. Miguel Alzate
  2. Thursday, 21 May 2020 15:44 PM UTC
Hi,



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.
  1. Helpful
  1. Armeen Mazda @Appeon
  2. Thursday, 21 May 2020 15:46 PM UTC
Thanks for letting us know, and glad to hear it is resolved!
  1. Helpful
There are no comments made yet.
mike S Accepted Answer Pending Moderation
  1. Tuesday, 5 May 2020 15:18 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

this seems somewhat like your problem?:

https://www.ibm.com/support/pages/sql30081n-tcpip-communication-errors

 

 

Comment
  1. Miguel Alzate
  2. Saturday, 9 May 2020 15:44 PM UTC
Thanks Mike for your answer. Do you know which protocol does the Appeon IBM DB2 driver use?
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.