IBM Support

IC78478: IMPROVE VIEW MQT MATCHING FOR INSERT STATEMENT WHOSE TARGET TABLE IS DGTT

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When a query references a view and the view has a view MQT (in
    definition of "select * from <view_name>"), the view may be
    replaced with view MQT. For an INSERT statement, to get the view
    MQT matching, the INSERT source subquery was required be a
    "SELECT from <view_name>". This APAR removes that restriction of
    source subquery format for the INSERT statement whose target
    table is DGTT (Declared Global Temporary Table).
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All DB2 Users are affected.                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * IMPROVE VIEW MQT MATCHING FOR INSERT STATEMENT WHOSE TARGET  *
    * TABLE IS DGTT                                                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 V9.7 FP5 to avail fix for this APAR.          *
    ****************************************************************
    

Problem conclusion

  • APAR first fixed in DB2 V9.7 FP5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC78478

  • 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-09-02

  • Closed date

    2011-12-08

  • Last modified date

    2011-12-08

  • 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

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC78478

Modified date: 08 December 2011