We are trying to conduct some assessment on the application that use CONNX. Specifically, I like to know if there is any more detailed logging of the JDBC server I can have aside from the level 1 and 2 that I can configure with the Configuration Manager.
I think that when an SQL insert comes to the CONNX JDBC Server, the sql insert is converetd into Adabas commands by the sql gateway client running in the JDBC server space. Is there a way I can figure out
- when the SQL Gateway client issue each of the Adabas command to the SQL Gateway server on the mainframe
- when the command reaches the Adabas SQL Gateway server on the mainframe.
- when the SQL Gateway server on the mainframe sends the command over to Adabas.
Adabas processes the command very quickly so I have no issue there.
What can I do to gather the statistics I need?