DB2 FOR LUW / DB2FORLUW / 970 - DB2

MQTs are not considered for rewrite matching in insensitive 
scrollable cursor queries.  This may result in missed 
opportunities in performance optimization. 
 
NOTE: Retrieving result set of queries using scrollable cursors 
has performance overhead.  Even with MQT routing, performance 
may not be as good as non-scrollable cursors queries. 
Scrollable cursors should be used only when required.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 9.                       * 
****************************************************************

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
 

First fixed in DB2 Version 9.7 Fix Pack 9.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC97001 IC97011 
Nachfolger : 

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

06.03.2013
17.12.2013
17.12.2013

9.7.FP9