DB2 - Problembeschreibung
Problem IT07212 | Status: Geschlossen |
ASYNCHRONOUS PARTITION DETACH MIGHT FAIL ON TABLE MARKED UNAVAILABLE IF TABLE CONTAINS GENERATED COLUMN | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
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. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 10.1 Fix Pack 5 or higher. * **************************************************************** | |
Local-Fix: | |
- restore from a full database backup. - contact DB2 support to run db2dart in service mode to mark table as available, which will allow detach to complete. Once detach completes, table will have to be dropped and rebuilt. | |
Lösung | |
Problem first fixed in DB2 version 10.1 Fix Pack 5. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 18.02.2015 26.07.2015 26.07.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.5 |