Our shop uses connx JDBC on windows to access our Adabas DB on the mainframe via an sql gateway which resides on the mainframe as well.
As development progresses, we realize that most of our sql can be complex. We use many sql functions for date processing, order by, case, decode, substring, etc. We often have to process billion of child rows to retrieve the desired information. This could mean a significant amount of work being handled by the jdbc server.
We are thinking of running the connx jdbc server on a Linux platform rather than on Windows 2008 r2.
We would appreciate if you can share your experience running the connx jdbc server on Linux and its performance. Best if you can share any benchmark that you have done with connx jdbc on both platforms.
Any information from you would be helpful.
Many thanks in advance.