|
Problem IC80648
|
Status: Closed |
SQL0262N IS RETURNED WHEN DETACHING PARTITION FROM A RANGE-PARTITIONED MQT IN DPF ENV |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Use the workaround or update to version 9.7 fixpack 6 or *
* newer fixpacks. *
**************************************************************** |
| Local Fix: |
Drop and recreate the MQT. |
| available fix packs: |
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
|
| Solution |
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. |
| Workaround |
Drop and recreate the MQT. |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC84560
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.01.2012
11.06.2012
11.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
