|
Problem IC79114
|
Status: Closed |
INSTANCE CRASHES WHEN STORED PROCEDURE WITH GLOBAL VARIABLES USING ROW OR ARRAY DATA TYPE IS INSTALLED IN SMP ENVIRONMENT |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to v9.7 Fix pack 6 *
**************************************************************** |
| Local Fix: |
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. |
| available fix packs: |
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
|
| Solution |
Problem was first fixed in Version 9.7 Fix Pack 6 |
| Workaround |
see Local Fix |
| Comment |
FIN |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 07.10.2011
12.07.2012
12.07.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
