Informix

  • 1.  InformixHQ Last Level 0 Backup Alert

    Posted 16 days ago
    Hi,

    what is the correct value for the alert?

    The Alert i got is this one:

    InformixHQ Alert on xxxx - Informix Backup to old: Last Level 0 Backup of 1 (1637089204,0) is greater than 2,0

    I want an alert i my last level 0 backup is older than 2 days but it looks like 1637089204 is an absolut time value and not the time span since the last level 0 backup.

    Thanks.

    ------------------------------
    Josef Albert
    ------------------------------


  • 2.  RE: InformixHQ Last Level 0 Backup Alert

    Posted 15 days ago
    hi, may be you should create a custom sensor with :
    select dbsnum,dbinfo('utc_to_datetime',level0)
    from sysdbstab
    where day(date(dbinfo('utc_to_datetime',level0)))<=day(today)-2


    ------------------------------
    jack rage
    ------------------------------



  • 3.  RE: InformixHQ Last Level 0 Backup Alert

    Posted 15 days ago
    Thanks, with the custom sensor it works.

    ------------------------------
    Josef Albert
    ------------------------------