DB2 FOR LUW / DB2FORLUW / 970 - DB2

When detaching a partition from a range partitioned materialized 
query table (MQT) in DPF environment, error sqlcode SQL0262N 
gets returned. Currently, both detach and attach operation are 
not supported on partitioned MQT in db2 version 9.1, 9.5 and 
9.7. 
 
The fix of this APAR will change the error message to 
acknowledge the user regarding the limitation.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All.                                                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Use the workaround or update to version 9.7 fixpack 6 or     * 
* newer fixpacks.                                              * 
****************************************************************

Drop and recreate the MQT.

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
 

This problem is first fixed in db2 version 9.7 fixpack 6. 
The fix for this APAR does not support either detach or attach 
operation on partitioned MQT. The fix only change the error 
message in order to acknowledge the user regarding the 
limitation.

Drop and recreate the MQT.

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

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

03.01.2012
11.06.2012
11.06.2012

9.7.FP6