Hello
I have a simple question.
ACE offers a set of “service” functions which retrieve internal JDBC data.
Examples:
SELECT
CNXCURRENTCONNECTIONS()
,CNXPEAKCONNECTIONS()
,CNXTOTALCONNECTIONS()
,CNXCURRENTSTATEMENTS()
,CNXPEAKSTATEMENTS()
,CNXTOTALSTATEMENTS()
Is there a “service” function available which checks whether defined data servers are “up and running”?
I ask for something like a “ping” with no real data access.
Background:
If you define multiple data servers für a data base (either as failover or for load balancing), it would be nice to know if these data servers are really “up and running”. I thinks about monitoring etc.
Any feedback is welcomed.
Kind regards Christian