Informix

 View Only

  • 1.  InformixHQ Last Level 0 Backup Alert

    Posted Wed November 17, 2021 10:15 AM
    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
    ------------------------------

    #Informix


  • 2.  RE: InformixHQ Last Level 0 Backup Alert

    Posted Thu November 18, 2021 05:38 AM
    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
    ------------------------------

    Original Message


  • 3.  RE: InformixHQ Last Level 0 Backup Alert

    Posted Fri November 19, 2021 03:53 AM
    Thanks, with the custom sensor it works.

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

    Original Message