DB2 FOR LUW / DB2FORLUW / 970 - DB2

When running the INSPECT command with the INDEXDATA option, the 
INSPECT tool might crash and bring down the database if it 
encounters a record ID in the index that points to a page beyond 
the end of the table space in which the table resides.  The 
following message will appear in the db2diag.log: 
 
2013-03-11-13.15.08.375329-240 I4470761E572        LEVEL: Error 
PID     : 19456                TID  : 469975076641 PROC:db2sysc 
0 
INSTANCE: db2inst1             NODE : 000          DB   : sample 
APPHDL  : 0-25448              APPID: 10.191.38.43.38338.1303111 
AUTHID  : ABCDEF 
EDUID   : 643                  EDUNAME: db2agent (LDDW) 0 
FUNCTION: DB2 UDB, buffer pool services, sqlbLatchPoolRange, 
probe:20 
MESSAGE : ZRC=0x84020009=-2080243703=SQLB_RC_PG_NUM_ERR 
          "Page number exceeds max -8100" 
          DIA8709E Segmented table page number was too high. 
 
There will also be a signal #6 with the following functions on 
the stack: 
 
sqle_panic 
sqlb_panic 
sqlbLatchPoolRange 
sqlbReadPage 
sqlbGetPageFromDisk 
sqlbfix 
sqldFetchDirect 
... 
sqlirdk 
sqldIndexFetch 
sqldRowFetch 
dartScanINXDAT 
... 
dartInspect 
sqlrinspect 
sqlrr_inspect 
 
The fix will have INPSECT report the error without bringing down 
the database.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.7.0.9.                              * 
****************************************************************

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
 

The problem is first fixed in DB2 version 9.7.0.9.

keiner bekannt / siehe Local-Fix

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

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

17.04.2013
16.12.2013
16.12.2013

9.7.0.9