| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IC95655 | Status: Closed |
WHEN USING ADMIN_MOVE_TABLE, THE STAGING AND TARGET TABLE IS NOT CLEANED DURING THE CANCEL OPERATION WHEN INIT PHASE FAILS. | |
| product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
| Problem description: | |
When using the ADMIN_MOVE_TABLE procedure, there are occasions
where it would fail due to various errors. To recover/cancel the
ADMIN_MOVE_TABLE procedure, a CANCEL option will be used.
However the CANCEL option will not do anything to fix the
problem as it would fail to remove the staging table created by
the ADMIN_MOVE_TABLE procedure.
So far this issue has only occured during if the problem occurs
during the INIT phase of the ADMIN_MOVE_TABLE procedure.
.
The problem can be reproduced using the following steps...
.
$ db2trc on -crash
DB2.DBAPPEXT_UTIL.adminotm_Otm_createStagingTable.exit
Trace is turned on
.
$ db2 "call
admin_move_table('TEST','TAB1','','','','','','','','','INIT,TRA
CE')"
SQL1224N The database manager is not able to accept new
requests, has
terminated all requests in progress, or has terminated the
specified request
because of an error or a forced interrupt. SQLSTATE=55032
.
$ db2trc off
Trace is already off; no action was taken.
.
$ db2 list tables for schema test
.
Table/View Schema Type Creation
time
------------------------------- --------------- -----
--------------------------
TAB1 TEST T
2013-04-25-01.49.38.397285
TAB1AABYVRs TEST T
2013-04-25-02.10.29.760057
TAB1AABYVRt TEST T
2013-04-25-02.10.29.499973
.
3 record(s) selected.
.
$ db2 "select substr(key,1,30), substr(value,1,30) from
systools.admin_move_table"
.
1 2
------------------------------ ------------------------------
STAGING TAB1AABYVRs
LOCK 2013-04-25-02.10.29.243344
STATUS INIT
AUTHID TANJINXU
VERSION 09.07.0007
INIT_START 2013-04-25-02.10.29.337336
INDEXSCHEMA
INDEXNAME
TARGET TAB1AABYVRt
.
9 record(s) selected.
.
$ db2 "call
admin_move_table('TEST','TAB1','','','','','','','','','cancel,t
race')"
.
Result set 1
--------------
.
KEY VALUE
-------------------------------- ---------------------------
.
0 record(s) selected.
.
Return Status = 0
.
$ db2 "select substr(key,1,30), substr(value,1,30) from
systools.admin_move_table"
.
1 2
------------------------------ ------------------------------
.
0 record(s) selected.
.
$ db2 list tables for schema test
.
Table/View Schema Type Creation
time
------------------------------- --------------- -----
--------------------------
TAB1 TEST T
2013-04-25-01.49.38.397285
TAB1AABYVRs TEST T
2013-04-25-02.10.29.760057
TAB1AABYVRt TEST T
2013-04-25-02.10.29.499973
.
3 record(s) selected.
.
$ db2 "call
admin_move_table('TEST','TAB1','','','','','','','','','INIT,TRA
CE')"
SQL0601N The name of the object to be created is identical to
the existing
name "TEST.TAB1AABYVRt" of type "TABLE". SQLSTATE=42710 | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * User using ADMIN_MOVE_TABLE procedure * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V10.1 Fix Pack 4 or higher * **************************************************************** | |
| Local Fix: | |
Identify the table used in the ADMIN_MOVE_TABLE and the equiva-
leng old target and old stagin table.
Example : Table used in ADMIN_MOVE_TABLE = TAB1
Do a "list tables for schema <schema name>".
The output will show...
$ db2 list tables for schema test
.
Table/View Schema Type Creation
time
------------------------------- --------------- -----
--------------------------
TAB1 TEST T
2013-04-25-01.49.38.397285
TAB1AABYVRs TEST T
2013-04-25-02.10.29.760057
TAB1AABYVRt TEST T
2013-04-25-02.10.29.499973
.
3 record(s) selected.
.
Where : TAB1 = Table specified in the ADMIN_MOVE_TABLE
TAB1AABYVRs and TAB1AABYVRt
= Is the old target and old stagin table. | |
| available fix packs: | |
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows | |
| Solution | |
Fixed in DB2 V10.1 Fix Pack 4 | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 02.09.2013 02.06.2014 02.06.2014 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 10.1.0.4 |
|