Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
  • 1.  InformixHQ - Sensor and Alert for "Backups per dbspace"

    Posted 19 hours ago

    Hi,

    In HQ, I have an alert set for the "backups per dbspace" sensor.
    Does anyone know what metric this sensor returns exactly?
    I'd like to create an alert with these conditions:
     
    Backups per dbspace - Last Level 0 Backup - is greater then: 24 (hours)

    The last value this alert returned was: (1752628201.0)

    InformixHQ Alert on TRICHEM-PRD - Backup archive: Last Level 0 Backup of 1 (1752628201.0) is greater than 24



    ------------------------------
    Leandro Kohler
    ------------------------------


  • 2.  RE: InformixHQ - Sensor and Alert for "Backups per dbspace"

    Posted 11 hours ago

    Hi Leandro.

    SELECT DBINFO ('utc_to_datetime',1752628201)

    returns

    2025-07-16 02:10:01

    in UK time zone.

    See: Using the 'utc_to_datetime' option



    ------------------------------
    Doug Lawry
    Oninit Consulting
    ------------------------------



  • 3.  RE: InformixHQ - Sensor and Alert for "Backups per dbspace"

    Posted 6 hours ago
    Hi Doug,

    Thanks for the information. However, I'm still not clear on how to use this metric in the InformixHQ sensor.