IBM Support

IC77113: QUERIES NOT ROUTED TO MQTS DUE TO DEFECTIVE MQT OR STATVIEW

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • DB2 compiler attempts to match query with all of the MQT and
    statview (statistical view) that depends on query referenced
    base table or nickname.  All of the MQT and statview are
    supposed to be present in catalog table sysibm.systables. In
    case an MQT or statview is attempted to match to query but it
    has no catalog row, the query compilation used to disable MQT
    matching.   The following message is displayed in the db2exfmt
    extended diagnostic for the query:
    
    Diagnostic Details:
         EXP0080W  The current usage of the statement or the
         statement containing update, delete or insert or
         constructs like sampling limits MQT matching.
    
    With this fix, the remaining MQT and statview are still matched
    to the query, and the unexpected MQT or statview is ignored by
    matching and a corresponding EXP0058W diagnostic message will
    capture its schema and name.
    

Local fix

Problem summary

  • DB2 compiler attempts to match query with all of the MQT and
    statview (statistical view) that depends on query referenced
    base table or nickname.  All of the MQT and statview are
    supposed to be present in catalog table sysibm.systables. In
    case an MQT or statview is attempted to match to query but it
    has no catalog row, the query compilation used to disable MQT
    matching.  The following message is displayed in the db2exfmt
    extended diagnostic for the query:
    
    Diagnostic Details:
        EXP0080W  The current usage of the statement or the
        statement containing update, delete or insert or
        constructs like sampling limits MQT matching.
    
    With this fix, the remaining MQT and statview are still matched
    to the query, and the unexpected MQT or statview is ignored by
    matching and a corresponding EXP0058W diagnostic message will
    capture its schema and name.
    

Problem conclusion

  • First fixed in DB2 Version 9.7 Fix Pack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC77113

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-06-22

  • Closed date

    2011-12-09

  • Last modified date

    2011-12-09

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

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

    IC82500

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC77113

Modified date: 09 December 2011