|
Problem IT09999
|
Status: Closed |
OWNER OF INDEX IS NOT PRESERVED WHEN ADMIN_MOVE_TABLE TARGET IS A BLU TABLE |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.5 Fix Pack 7. *
**************************************************************** |
| Local Fix: |
|
| Solution |
First fixed in DB2 Version 10.5 Fix Pack 7. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 10.07.2015
20.01.2016
20.01.2016 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.7
|
 |
