Suggestions on AUS monitoring
Posted in 2015
Hi All, I was referring Bens blog on monitoring AUS: https://informixdba.wordpress.com/2015/04/30/experience-with-auto-update-statist ics-aus/ I am trying to gather details on AUS monitoring; apart from below points what else I have to consider for AUS monitoring: 1) The parameters (AUS_AGE, AUS_CHANGE, AUS_AUTO_RULES, AUS_PDQ and AUS_SMALL_TABLES) are set correctly (in case they change if you rebuild the sysadmin database, for example). 2) No errors reported in the aus_command table (aus_command.aus_cmd_state='E') 3) All statistics and distributions are sufficiently up to date. 4) The window you give the refresh job to run in is long enough. No pending commands at the end of the refresh task window (aus_command.aus_cmd_state='P') Thanks & Regards, Pravin Bankar