DB2 FOR LUW / DB2FORLUW / A10 - DB2

When a load from cursor is used and the SQL statement text used 
to declare the cursor is large ( > 16k bytes ) 
There can be an instance crash if the Change History event 
monitor is enabled e.g. : 
 
db2 "CREATE EVENT MONITOR CHGHIST  FOR CHANGE HISTORY WHERE 
EVENT IN (ALL)     WRITE TO TABLE" 
db2 " SET EVENT MONITOR CHANGE_HISTORY STATE 1" 
 
A stack trace may have this : 
 
 generateEvent__18sqmEvmonGenFactoryXT19sqmEvmonType_p 
 collectEventData__34sqmEvmonUtilStart_Collector_poli 
 generateEvent__18sqmEvmonGenFactoryXT19sqmEvmonType_ 
 sqmGenerateLoadStartEvent__FCP8sqlrr_cbP26sqluCLoadR 
 sqlu_register_table_load__FP26sqluCLoadRequestDescri 
 sqluvtld_route_in__FP12SQLE_DB2RA_T 
... 
 
but could vary depending on the size and the extent of the 
memory overwrite that triggers the trap.

**************************************************************** 
* USERS AFFECTED:                                              * 
* all                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade the database server to DB2 V10.1 FP3 or higher.      * 
****************************************************************

Reduce the size of SQL statement e.g. by declaring some views. 
Disable the Change history event monitor: db2 " SET EVENT 
MONITOR CHANGE_HISTORY STATE 0" 
for the duration of the load.

DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

This problem was first fixed in v10.1 Fix Pack 3

not known / see Local fix

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

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

18.02.2013
24.11.2014
24.11.2014