DX Unified Infrastructure Management

  • 1.  Monitoring Firebird SQL databases

    Posted Dec 14, 2018 06:18 AM

    Hi all,

     

    I was wondering if I can use the SQL probes (sql_response and or sqlserver probe to monitor Firebird databases.

     

    Has anyone done this before?

     

    Regards,

    Rob



  • 2.  Re: Monitoring Firebird SQL databases

    Posted Dec 14, 2018 09:24 AM

    sqlserver is just for MS SQL

    sql_response looks like it should.

    sql_response (SQL Server Response Monitoring) Release Notes - CA Unified Infrastructure Management Probes - CA Technolog… 

    The SQL Server Response Monitoring (sql_response) probe uses ADO or ODBC connections to execute SQL queries and monitor SQL server databases. The probe then evaluates the result of the query (for example, response time, number of returned rows, and returned value) to generate alarms and QoS.



  • 3.  Re: Monitoring Firebird SQL databases

    Posted Dec 14, 2018 11:33 AM

    It would be completely unsupported but the jdbc_response probe, while it is intended to only work with the 4 or 5 preconfigured drivers, can be coerced to work with another open jdbc driver assuming firebird has one. The trick is to use a connection string that would be valid with one of the supported databases but targets the firebird db connection too. That leaves the probe thinking it is talking to Oracle (for instance) but passing commands to the db you have configured. 

     

    One of the many other alternatives is to write your queries in a script and use logmon to call them. And parse the data from there. Obviously, you are left needing to implement all the error handling yourself but that isn't that onerous.