DB2 - Problem description
Problem IT38011 | Status: Closed |
ADMIN_MOVE_TABLE FAILS WITH ERROR WHEN MOVING TABLE WITH USAGE LIST AND SPECIAL CHARACTERS | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
Steps to reproduce: SET CURRENT SCHEMA OTMSPECIALCHARS CREATE TABLE """TABLENAME_ENCLOSEDBY_DQ""" (I INT NOT NULL, VC VARCHAR(30) NOT NULL) ORGANIZE BY ROW CREATE USAGE LIST """USAGE_LIST_ENCLOSEDBY_DQ""" FOR TABLE OTMSPECIALCHARS."""TABLENAME_ENCLOSEDBY_DQ""" LIST SIZE 50 WHEN FULL WRAP SYSPROC.ADMIN_MOVE_TABLE('OTMSPECIALCHARS','"TABLENAME_ENCLOSEDB Y_DQ"','','','MOVE,TRACE') SQL0204N "OTMSPECIALCHARS.TABLENAME_ENCLOSEDBY_DQ" is an undefined name. SQLSTATE=42704 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Db2 Version 11.5 * **************************************************************** * PROBLEM DESCRIPTION: * * See description. * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 Version 11.5.7.0 (11.5 Mod 7 Fix Pack 0) * **************************************************************** | |
Local Fix: | |
Drop usage list before move and re-recreate after move is complete. | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Db2 Version 11.5 * **************************************************************** * PROBLEM DESCRIPTION: * * See 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) |