DB2 FOR LUW / DB2FORLUW / 970 - DB2

There are timing conditions which could lead to SQL0901N 
ENCOUNTERED BY APD CLEANUP PROCESSING DURING RANGE PARTITION 
DETACH. This symptom is similar to APAR IC71664. But it is 
caused by timing conditions not yet addressed by that APAR fix. 
 
Both db2pd and db2 list utilities show ASYNCHRONOUS PARTITION 
DETACH is performing "Finalize detach for partition ...". In the 
db2diag.log, the -901 reported for the asynchronous detach 
process may appear similar to the entry below. 
 
2012-02-13-09.17.05.210933-480 I4180806A876       LEVEL: Severe 
PID     : 4456546              TID  : 14281       PROC : db2sysc 
0 
INSTANCE: dwd01                NODE : 000         DB   : DWD01 
APPHDL  : 0-22322              APPID: *N0.DB2.120311163320 
AUTHID  : DWD01 
EDUID   : 14281                EDUNAME: db2taskp (DWD01) 0 
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, 
probe:300 
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes 
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -901   sqlerrml: 60 
 sqlerrmc: A hard invalidation is already taking place for this 
object! 
 sqlerrp : SQLRA0B5 
 sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 
0x00000000 
           (4) 0x00000000      (5) 0xFFFFFFEC      (6) 
0x00000000 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
           (7)      (8)      (9)      (10)        (11) 
 sqlstate:

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

N/A

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
 

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: IC84549 
Nachfolger : 

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

28.02.2012
13.06.2013
13.06.2013

9.7.FP6