IBM Support

IT32614: THE AUS_WORK_LOCK TABLE REMAINS ALONG WITH TK_ATTRIBUTES OF 924 WHEN AUS EVALUATOR STARTS WHEN AUS REFRESH IS STILL RUNNING

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

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

Local fix

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

Problem conclusion

  • Fixed in Informix Server 12.10.xC15 and 14.10.xC5.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT32614

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-04-21

  • Closed date

    2020-12-29

  • Last modified date

    2020-12-29

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    INFORMIX SERVER

  • Fixed component ID

    5725A3900

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10"}]

Document Information

Modified date:
30 December 2020