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