Informix - Problem description
Problem IT32614 | Status: Closed |
THE AUS_WORK_LOCK TABLE REMAINS ALONG WITH TK_ATTRIBUTES OF 924 WHEN AUS EVALUATOR STARTS WHEN AUS REFRESH IS STILL RUNNING | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
The AUS evaluator and AUS refresh are scheduled (by default) to run around 1am. The days of the week can be configured. If the system is very big, then the refresh might run for over 24 hours and when this occurs, the next evaluator run will start and immediately stop but the aus_work_lock table is not dropped, the tk_attributes is still set to 924 (and not 412) and the tk_next_execution value might also not be correct depending on how the AUS evaluator has been configured. This means that the AUS evaluator will no longer run, which also means that there is no refresh of statistics and this could lead to query performance problems. The problem can be resolved by manually dropping the aus_work_lock table and updating tk_attributes to 412 (and if needed, altering tk_next_execution to a future datetime value) for the AUS evaluator record. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC5. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC5. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC5. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC5. * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC15 and 14.10.xC5. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 21.04.2020 29.12.2020 29.12.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |