DB2 FOR LUW / DB2FORLUW / 970 - DB2

When INSPECTing a damaged object DB2 may read bad pages into the 
bufferpool without detecting them. 
 
This happens with pages that belong to the same object and 
therefore look like a valid page. 
The actual corruption is the data pages being out of sync with 
the objects EMPs. 
 
A possible sequence of events that may result in the above 
corruption and instance PANIC is: 
- a not logged operation (NLI) against an object is 
aborted/rolled back 
- the object is in drop pending state after the NLI operation 
- INSPECT with option ERROR STATE ALL is executed against the 
object 
- error SQL1224N is hit and instance is brought down 
 
A possible stack may look like following: 
 
 ... 
 sqlb_panic 
 sqlbufix 
 dartCall_sqlbUnFixPage 
 dartUnfixPage 
 dartScanDAT 
 dartScanTable 
 dartScanTablespace 
 dartInspect 
 
This APAR will ensure DB2 detects the corruption upon fixing the 
page (sqlbfix) instead of successfully loading it into 
bufferpool and fail upon releasing/unfixing the page from 
bufferpool.

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

1) For objects with questionable states, do not use the FOR 
ERROR STATE ALL clause with INSPECT. 
2) For objects with questionable states, use db2dart to inspect 
them.

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 DB2 Version 9.7 Fix Pack 6.

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC84265 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

04.01.2012
11.06.2012
11.06.2012

9.7.FP6