|
Problem IC84560
|
Status: Closed |
SQL0262N IS RETURNED WHEN DETACHING PARTITION FROM A RANGE-PARTITIONED MQT IN DPF ENV |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - 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: *
* Update to fixpack 1 or later fixpacks. *
**************************************************************** |
| Local Fix: |
Drop and recreate the MQT. |
| available fix packs: |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
This problem is first fixed in db2 version 10.1 fixpack 1. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.06.2012
01.11.2012
01.11.2012 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.1
|
 |
| 10.5.0.1
|
|
