IBM Support

IT07079: UPDATE STATISTICS LOW CAN FAIL TO UPDATE SYSINDICES WITH STATISTICS WHEN INDEX WAS DISABLED AND AUTO STAT MODE IS ACTIVE

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

  • When AUTO_STAT_MODE is enabled in the onconfig the system
    catalog table sysindices may not be filled with the statistics
    for an index after an UPDATE STATISTICS LOW. Only the nrows
    column will then have the value current at the time of the
    update statistics run, other columns like levels, leaves,
    nunique and cluster will not have any values.
    
    This can happen when the index is created in disabled mode like
    "CREATE INDEX index_name ON TABLE table_name(column) DISABLED"
    and the UPDATE STATISTICS LOW is run while it still is disabled.
    
    When you enable the index with "SET INDEXES FOR TABLE table_name
    ENABLED" and do an UPDATE STATISTICS LOW an active
    AUTO_STAT_MODE can prevent the statistics from being updated
    when not sufficiently many changes on the table did happen after
    the last UPDATE STATISTICS LOW (depending on the STATCHANGE
    setting in the configuration).
    
    Missing statistical information can lead to inappropriate query
    plans and hence to intolerable query run times.
    
    When you add the FORCE option to your UPDATE STATISTICS LOW run
    at a time when the indexes are enabled it will ensure the
    statistics to be gathered and written to sysindices, regardless
    of the AUTO_STAT_MODE and STATCHANGE settings.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to IBM Informix Server 12.10.xC6                      *
    ****************************************************************
    

Problem conclusion

  • Problem Fixed In IBM Informix Server 12.10.xC6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT07079

  • 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

    2015-02-10

  • Closed date

    2016-01-19

  • Last modified date

    2016-01-19

  • 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

  • RA10 PSN

       UP

  • RA10 PSY

       UP

  • RB10 PSN

       UP

  • RB10 PSY

       UP

  • RB50 PSN

       UP

  • RB50 PSY

       UP

  • RB70 PSN

       UP

  • RB70 PSY

       UP

  • RC10 PSN

       UP

  • RC10 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
19 January 2016