DB2 FOR LUW / DB2FORLUW / 970 - DB2

If an OLAP query has a row that is wider than 65535 bytes, then 
it may cause a memory corruption and crash. OLAP queries require 
the buffering of data in memory, but a logic problem when 
computing the buffer size causes DB2 to chose a buffer size that 
is too small to contain the wide row. This later results in 
memory corruption when the row gets copied into the 
insufficiently sized buffer, thereby overwriting information 
beyond that buffer in memory. 
 
Since this is a memory corruption, there is not always a 
consistent problem signature to uniquely identify the case since 
it depends on what information gets corrupted. If a memory debug 
setting is used, like db2set DB2MEMDBG=PROTECT, then the 
corruption can be caught at the time of the overwrite, with the 
following stack traceback: 
 
sqlri_buffer_add 
sqlri_scalag 
sqlriSectInvoke 
sqlrr_process_fetch_request 
sqlrr_open

**************************************************************** 
* USERS AFFECTED:                                              * 
* OLAP queries                                                 * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Install fix                                                  * 
****************************************************************

Reduce the width of the row flowing into scalag, or rewrite the 
query so that it doesn't select rows wider than 65535 bytes.

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
 

Install Fix

keiner bekannt / siehe Local-Fix

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

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

09.02.2012
06.06.2012
06.06.2012