DB2 FOR LUW / DB2FORLUW / 970 - DB2

Instance crashes when calling a certain SQL stored procedure 
installed on a Symmetric Multi-Processing (SMP) environment 
-i.e. INTRA_PARALLEL dbm cfg is set to ON. The problem manifests 
in SMP mode only - when the module that works with global 
variables of row  or array data types in SMP is executed 
multiple times. 
FODC Trap file is generated. 
One of the possible stacks may be as follows: 
 
 
0        sqlvsht2dec 
1        sqlvcnum 
2        sqlrxcon2 
3        sqlriRowDescCopy 
4        sqlvSqlPLCopyRow 
5        sqlraERTSetValue 
6        sqlriGlobalVarAssignRow 
7        sqlriSectInvoke 
8        sqlrr_process_execute_request 
9        sqlrr_execute 
10       pvmPackage::executeSection 
11       PVM::executeQuery

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to v9.7 Fix pack 6                                    * 
****************************************************************

To disable Intra-partition parallelism use this command:- db2 
update dbm cfg using INTRA_PARALLEL NO 
Disable intra-partition parallelism, drop the procedure, db2stop 
, db2start, recreate the procedure - to get a non-SMP section. 
Then enable parallelism, then run db2start, and continue. This 
should allow execution of the SQL that involves global registry 
variable of row or array data type with no SMP processing.

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

see Local Fix

FIN

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

07.10.2011
12.07.2012
12.07.2012

9.7.FP6