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 23 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 15 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 10 hours ago
    Hi Doug,

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