I am experiencing an error that occurs 2 out of 3 times when trying to refresh my table list in my connection to a DB2 database.
Context: EasyMporph is installed in an AWS Workspace, hosted in Virgina. The DB2 Instance is sitting on a server in Chile. I am accessing the DB with the EasyMorph connector. It used to work fine for about 2 months. During this week I have automated logics failing. One out of two types of error message appear:
ERROR [HY000] [IBM][System i Access ODBC Driver]Error in host server data stream
ERROR [HY000] [IBM][System i Access ODBC Driver][DB2 for i5/OS]
When I manually run the logic, these errors happen 2 out of 3 times. I have not been able to detect any issue that could explain this problem. When I run the same logic from a local machine, it works fine.
Could you please help me with ideas of how to manage this issue?
Thanks in advance!