DB2 FOR LUW / DB2FORLUW / 970 - DB2

DB2 can crash with the following stack if we have the Statement 
Monitor switch set to ON 
 
 
0        sqm_add_ss_counters 
1        sqm_take_stmt_snap 
2        sqm_snap_appl 
3        sqlmonssagnt 
4        sqlmonssbackend 
5        sqlesrvr 
6        sqleMappingFnServer 
7        sqlerKnownProcedure 
8        sqlerCallDL 
9        sqljs_ddm_excsqlstt.fdpr.clone.96 
10       sqljsParseRdbAccessed 
11       sqljsParse.fdpr.clone.1029 
12       sqljsSqlam 
13       sqljsDriveRequests 
14       sqljsDrdaAsInnerDriver 
15       sqljsDrdaAsDriver 
16       sqeAgent::RunEDU 
17       sqzEDUObj::EDUDriver 
18       sqloEDUEntry

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* The problem is due to internally changing a structure        * 
* without holding the latch for it.                            * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 and Fix Pack 4                    * 
****************************************************************

Set Statement monitor switch to OFF (DFT_MON_STMT) and make sure 
that the Statement Monitor switch is not turned on for the 
sessions (db2 get monitor switches). 
Note that db2top -s Statement option has Statement Monitor 
switch turned on by default so using db2top to monitor 
Statements will make the system vulnerable to this APAR.

DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 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
 

Problem was first fixed in DB2 Version 9.7 and Fix Pack 4

keiner bekannt / siehe Local-Fix

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

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

19.10.2010
28.04.2011
28.04.2011

9.7.