DB2 - Problem description
Problem IT38013 | Status: Closed |
ADMIN_MOVE_TABLE MIGHT FAIL WITH SQL2103N RC=16 if RUNSTATS profile contains NUM_FREQVALUES /NUM_QUANTILES | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
ADMIN_MOVE_TABLE might fail with SQL2103N RC=16 if RUNSTATS profile contains DEFAULT NUM_FREQVALUES x NUM_QUANTILES y clause and x or y match the database configuration values for NUM_FREQVALUES and/or NUM_QUANTILES. Steps to reproduce: drop table tst.t1; update db cfg using NUM_FREQVALUES 10; create table tst.t1(i int not null, c varchar(10), primary key(i)); RUNSTATS on TABLE tst.T1 WITH DISTRIBUTION ON KEY COLUMNS DEFAULT NUM_FREQVALUES 100 AND INDEXES ALL SET PROFILE ONLY; select varchar(statistics_profile, 120) from SYSCAT.TABLES WHERE TABSCHEMA = 'TST' AND TABNAME = 'T1'; update db cfg using NUM_FREQVALUES 100; call ADMIN_MOVE_TABLE('TST','T1','','','MOVE,TRACE'); | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Db2 Version 11.5 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 Version 11.5.7.0 (11.5 Mod 7 Fix Pack 0) * **************************************************************** | |
Local Fix: | |
Use FORCE option to complete the move. | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Db2 Version 11.5 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 Version 11.5.7.0 (11.5 Mod 7 Fix Pack 0) * **************************************************************** | |
Comment | |
Problem was first fixed in Db2 Version 11.5.7.0 (11.5 Mod 7 Fix Pack 0) | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 16.08.2021 04.10.2021 04.10.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |