DB2 FOR LUW / DB2FORLUW / B50 - DB2

Using ADMIN_MOVE_TABLE with COPY_STATS option might fail with
SQL2102N RC 28 when source table has inconsistent statistics
according to current update statistics rules.

Cases when this have encountered:
- Inconsistent statistics on source table.
- PCTPAGESSAVED different between source and target.
ADMIN_MOVE_TABLE tries to update this statistic while it cannot
be updated.
- Source table is compressed, then AVGCOMPRESSEDROWSIZE cannot
be applied because the value is bigger than AVGROWSIZE.

This change aims to handle some known cases better with the
purpose of establishing the statistics like on source table that
are relevant for SQL optimizer decisions. Instead of returning
SQL2102N RC 28, ADMIN_MOVE_TABLE will directly return SQL1227N
error message when copying the statistics fails, that the root
cause can be easier determined.

****************************************************************
* USERS AFFECTED:                                              *
* Customers using ADMIN_MOVE_TABLE with COPY_STATS option.     *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to next release or avoid using COPY_STATS.           *
****************************************************************

Continue ADMIN_MOVE_TABLE with SWAP without COPY_STATS option.
ADMIN_MOVE_TABLE will create new statistics using RUNSTATS
command if necessary.

****************************************************************
* USERS AFFECTED:                                              *
* Customers using ADMIN_MOVE_TABLE with COPY_STATS option.     *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to next release or avoid using COPY_STATS.           *
****************************************************************

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

12.03.2021
03.08.2021
03.08.2021