DB2 FOR LUW / DB2FORLUW / 970 - DB2

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

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

DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

APAR first fixed in DB2 V9.7 FP5

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

02.09.2011
08.12.2011
08.12.2011

9.7.FP5