Asynchronous partition detach will fail under following
conditions:
- table is defined with GENERATED column (e.g GENERATED BY
DEFAULT AS IDENTITY [...])
- table is marked as unavailable before the detach, either by
rollback of non-logged transaction or non-recoverable LOAD
Once detach is run, it will never complete. LIST UTILITIES SHOW
DETAIL will report
$ db2 list utilities show detail
ID = 2
Type = ASYNCHRONOUS PARTITION DETACH
Database Name = SAMPLE
Partition Number = 0
Description = Finalize detach for partition
'0' of table 'DB2V97 .T1' and make table 'DB2V97
.T1_DET_PART0' available
Start Time = 11/27/2014 12:39:56.497301
State = Waiting
and following messages will be logged to db2diag.log:
2014-11-25-09.51.06.140001+060 E221218E764 LEVEL:
Warning
[...]
EDUID : 408 EDUNAME: db2taskp (SAMPLE) 0
FUNCTION: DB2 UDB, data management, sqldSetupSQLCA, probe:3
MESSAGE : ADM5570W Access was attempted on an unavailable
object with id "4"
in tablespace "7" for table "DB2V97.T1_DET_PART0". If
the object is
a table it will have to be dropped. If the object is
a partition it
will have to be detached. If the object is a
non-partitioned index
the index will have to be dropped.
[...]
FUNCTION: DB2 UDB, catalog services, sqlrlAlterPartAltCol,
probe:400
RETCODE : ZRC=0x8004004B=-2147221429=SQLD_TBL_NOTAVAIL
"Table not available after rollforward"
[...]
EDUID : 408 EDUNAME: db2taskp (SAMPLE) 0
FUNCTION: DB2 UDB, catalog services, sqlrlAlterDetachAltCol,
probe:300
RETCODE : ZRC=0x8004004B=-2147221429=SQLD_TBL_NOTAVAIL
"Table not available after rollforward"
[...]
EDUID : 408 EDUNAME: db2taskp (SAMPLE) 0
FUNCTION: DB2 UDB, AIC, apdTaskProcessor, probe:1215
MESSAGE : ZRC=0x8004004B=-2147221429=SQLD_TBL_NOTAVAIL
"Table not available after rollforward"
DATA #1 : String, 60 bytes
APD ERROR DURING PROCESSING: poolID/objectID/partitionID !!!
DATA #2 : unsigned integer, 2 bytes
65530
DATA #3 : unsigned integer, 2 bytes
32768
DATA #4 : unsigned integer, 2 bytes
0
[...]
EDUID : 408 EDUNAME: db2taskp (SAMPLE) 0
FUNCTION: DB2 UDB, AIC, apdTaskProcessorCleanup, probe:194
MESSAGE : ZRC=0x8004004B=-2147221429=SQLD_TBL_NOTAVAIL
"Table not available after rollforward"
CALLED : DB2 UDB, AIC, apdTaskProcessor
RETCODE : ZRC=0x82A90066=-2102853530=ABP_SUSPEND_TASK_PRO
"Suspend the task processor"
DATA #1 : String, 28 bytes
Source Table Schema and Name
DATA #2 : String, 8 bytes
DB2V97
DATA #3 : String, 2 bytes
T1
DATA #4 : String, 12 bytes
Partition ID
DATA #5 : unsigned integer, 2 bytes
0
DATA #6 : String, 28 bytes
Target Table Schema and Name
DATA #7 : String, 8 bytes
DB2V97
DATA #8 : String, 12 bytes
T1_DET_PART0
Access attempt to the table will fail with SQL1477N. User will
also not be able to drop the table as error SQL1477N will be
returned. |
