DB2 - Problembeschreibung
Problem IT09999 | Status: Geschlossen |
OWNER OF INDEX IS NOT PRESERVED WHEN ADMIN_MOVE_TABLE TARGET IS A BLU TABLE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
During admin_move_table procedure the owner of indexes does change to the caller of the procedure when the procedure is called with option 'ORGANIZE BY COLUMN' in order to move a table and its indexes from row organized to column organized (BLU table). The table itself keeps its original owner, only the indexes are affected. This change of the index owner may lead to authorization issues during later index operations, for example SQL0552N "USER1" does not have the privilege to perform operation "RENAME INDEX". SQLSTATE=42502 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.5 Fix Pack 7. * **************************************************************** | |
Local-Fix: | |
Lösung | |
First fixed in DB2 Version 10.5 Fix Pack 7. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 10.07.2015 20.01.2016 20.01.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.7 |