DB2 FOR LUW / DB2FORLUW / 970 - DB2

During partition detach against a range partitioned table, if an 
APD task is abnormally terminated (e.g. deadlock), its changes 
will be rolled back internally. The task will be picked up and 
retried later by the ABP agent, and it will rely on entries in 
SYSIBM.SYSJOBS and SYSIBM.SYSTASKS to restart and complete the 
detach. However, it is possible for these entries in 
SYSIBM.SYSJOBS and SYSIBM.SYSTASKS to be missing, in which case 
the detach tasks will never complete, and the partition will be 
stuck as "logically detached" (with STATUS='L' in 
SYSCAT.DATAPARTITIONS). The fix for this APAR will prevent such 
condition, but it does not (retroactively) fix the existing 
issue.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to Version 9.7 Fix Pack 6                             * 
****************************************************************

DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem was first fixed in Version 9.7 Fix Pack 6

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC84318 IC84607 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

20.10.2011
02.08.2012
02.08.2012

9.7.FP6