DB2 FOR LUW / DB2FORLUW / 970 - DB2

DB2 fails to respect the CURRENT MDC ROLLOUT MODE special 
register when a delete statement is compiled with the special 
register set to NONE and then the same delete statement is 
re-executed except this time with the special register set to 
IMMEDIATE or DEFERRED.  The first time the statement is 
executed, the plan is compiled with a regular delete operator 
and it is stored in the package cache.  The second execution of 
the statement executes the plan stored in the package cache, 
which contains a regular delete operator.  The regular delete 
operator does not check if the special register has changed. 
The problem does not occur if the special register is set to 
DEFERRED or IMMEDIATE when the statement is first compiled 
because then the cell delete operator will be used and this 
operator will check if the special register has changed.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.7.0.6.                              * 
****************************************************************

Recompile/rebind the package experiencing the problem.

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
 

The problem is first fixed in DB2 version 9.7.0.6.

keiner bekannt / siehe Local-Fix

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

26.08.2011
12.06.2012
12.06.2012

9.7.0.6