Oninit cdi / Archive
Talk to an expert →

InformixHQ Last Level 0 Backup Alert

Posted in 2021

Topics: Backup & Restore

Josef Albert — source: IBM Community (ConnectedCommunity.org) Informix forum

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

↪ replying to Josef Albert
jack rage — source: IBM Community (ConnectedCommunity.org) Informix forum

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 ------------------------------

↪ replying to jack rage
Josef Albert — source: IBM Community (ConnectedCommunity.org) Informix forum

Thanks, with the custom sensor it works. ------------------------------ Josef Albert ------------------------------