|
Problem IT25527
|
Status: Closed |
ADMIN_MOVE_TABLE: INDEX IS NOT GENERATED IF TARGET TABLE IS COLUMNAR
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
ADMIN_MOVE_TABLE automatically creates a generated index in case
the source table doesn't already have an index defined.
This is done to optimize the REPLAY phase. In the CLEANUP phase
this generated index is dropped again.
Until now, if the target table is columnar this generated index
was not created.
This was due to earlier limitations of secondary indexes on
columnar tables.
This change enables the creation of the generated index on the
columnar target table, if possible. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ADMIN_MOVE_TABLE on row table without index for a move to *
* BLU. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to next fixpack. *
**************************************************************** |
| Local Fix: |
create an index on the source table before invoking
ADMIN_MOVE_TABLE |
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 28.06.2018
05.09.2018
05.09.2018 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
