DB2 - Problem description
Problem IT36203 | Status: Closed |
ADMIN_MOVE_TABLE WITH COPY_STATS OPTION MIGHT FAIL WITH SQL2102NRC 28 | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
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. | |
Problem Summary: | |
**************************************************************** * 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. * **************************************************************** | |
Local Fix: | |
Continue ADMIN_MOVE_TABLE with SWAP without COPY_STATS option. ADMIN_MOVE_TABLE will create new statistics using RUNSTATS command if necessary. | |
Solution | |
Workaround | |
**************************************************************** * 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. * **************************************************************** | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 12.03.2021 03.08.2021 03.08.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |