|
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) |
