OAT Health advisor not populating alerts
Cherry found OAT Health Advisor not showing a dbspace over its threshold in Alerts, so no e-mail alerts were sent. Alexandre Marini said OAT is discontinued and suggested checking ph_alert errors and ph_threshold. Eric Vercelletto said InformixHQ is the successor, works on 12.10 and lightly tested on 11.70, and is incomplete, with more functionality expected in 14.10 FC4.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
We have OAT configured for one of the informix servers. It has failed to report space issue in one database. When we investigate the issue, we found that Health advisor is not populating data to Alerts window. We have a dbspace(data1dbs) is showing red and it has reached the threshold set in Health Advisor monitoring but Health Advisor is not populating this data in Alerts page. So we are not getting any alert to our mailbox due to this. What could be the reason? any suggestions? ------------------------------ Cherry ------------------------------ #Informix
Hi, Cherry. OAT is discontinued. Which Informix version are you using? Just in case, you can try to search for job execution errors, searching on ph_alert table. Also suggest checking on ph_threshold, ensuring that your task has being properly setup for alerting. Reference: https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.adref.doc/ids_adr_0275.htm ------------------------------ Alexandre Marini ------------------------------
Hello Alex, Thanks for your response. OAT is discontinued. - What is the alternative for OAT. is it InformixHQ? I know it is available with informix 14.1 version. My databases are of 11.7 and 12.1 version. will InformixHQ monitor lower version databases? ------------------------------ Cherry ------------------------------
HI Cherry, exact, Informix HQ is the official successor of OAT. It works on 12.10 and I have tested lightly on 11.70 and it seems to work too. The tool is based on SQL queries so at least a vast majority of functionality should work. It is not complete yet, but the 14.10 FC4 release should bring a lot of missing functionality ------------------------------ [eric] [Vercelletto] [] [Founder] [kandooerp.org] [Pont l'Abbé] [France] [+33 626 52 50 68] Disclaimer: My own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. ------------------------------