|
Problem IC84560
|
Status: Geschlossen |
SQL0262N IS RETURNED WHEN DETACHING PARTITION FROM A RANGE-PARTITIONED MQT IN DPF ENV |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to fixpack 1 or later fixpacks. *
**************************************************************** |
| Local-Fix: |
Drop and recreate the MQT. |
| verfügbare FixPacks: |
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
|
| Lösung |
This problem is first fixed in db2 version 10.1 fixpack 1. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 14.06.2012
01.11.2012
01.11.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.1
|
 |
| 10.5.0.1
|
|
