home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT07506 Status: Geschlossen

ASYNCHRONOUS PARTITION DETACH MIGHT FAIL ON TABLE MARKED UNAVAILABLE IF
TABLE CONTAINS GENERATED COLUMN

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - 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.5 Fix Pack 7 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.5 Fix Pack 7.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
04.03.2015
01.02.2016
01.02.2016
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.7 FixList