DB2 - Problem description
Problem IT38790 | Status: Closed |
THE ADMIN_MOVE_TABLE PROCEDURE MAY STUCK IN CANCEL PHASE. | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
If ADMIN_MOVE_TABLE procedure fails at the very beginning of INIT phase then it may not be possible to cancel it. Any subsequent execution of the ADMIN_MOVE_TABLE fail with error SQL2105N e.g db2 "CALL SYSPROC.ADMIN_MOVE_TABLE('MYSCHEMA','MYTABLE','TEST','TEST','TES T','','','','','','CANCEL')" SQL2105N The ADMIN_MOVE_TABLE procedure could not be completed because a prerequisite for running the procedure was not satisfied. Reason code: "11". SQLSTATE=5UA0M To confirm one hit the issue described following command can be used: db2 "select char(TABSCHEMA,20),char(tabname,60),key,char(value,70) from systools.ADMIN_MOVE_TABLE" If the output does not have following two records then it is high probably this APAR 1 2 KEY 4 -------------------- ------------------------------------------------------------ .. MYSCHEMA MYTABLE INDEXSCHEMA MYSCHEMA MYTABLE INDEXNAME .. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ADMIN_MOVE_TABLE users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 v11.5.7.1 * **************************************************************** | |
Local Fix: | |
One can execute following two inserts followed by ADMIN_MOVE_TABLE with CANCEL option Note: MYSCHEMA and MYTABLE need to be replaced with appropriate schema and table name for which ADMIN_MOVE_TABLE procedure failed db2 "insert into systools.ADMIN_MOVE_TABLE values ('MYSCHEMA', 'MYTABLE', 'INDEXSCHEMA', '')" db2 "insert into systools.ADMIN_MOVE_TABLE values ('MYSCHEMA', 'MYTABLE', 'INDEXNAME', '')" db2 "CALL SYSPROC.ADMIN_MOVE_TABLE('MYSCHEMA','MYTABLE','TEST','TEST','TES T','','','','','','CANCEL')" | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * ADMIN_MOVE_TABLE users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 v11.5.7.1 * **************************************************************** | |
Comment | |
Fix included in Db2 v11.5.7.1 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 25.10.2021 09.12.2021 09.12.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |