DB2 FOR LUW / DB2FORLUW / 970 - DB2

Instance abnormal termination might occur with following 
stack: 
 
Failing instruction at 000000000245F2DA offset: 0000000000000048 
in 
<?sqlno_order_normalize@@YAHPEAUsqlno_globals@@PEAUsqlno_order_c 
lass@@PEAUsqlno_plan_properties@@PEAUsqlno_apcb@@PEAPEAU2@W4SQLN 
N_BOOLEAN@@PEATsqlno_set@@@Z> <NotFound:-1> 
 
------RBP--------------RIP--------------ARGS-------------------- 
------------------------------------- 
0000000010A13DA0 000000000245F2DA 0000000010A13F68 
0000000000000000 0000000010A13C38 000007FE6443CDA0 offset: 
0000000000000048 in 
<?sqlno_order_normalize@@YAHPEAUsqlno_globals@@PEAUsqlno_order_c 
lass@@PEAUsqlno_plan_properties@@PEAUsqlno_apcb@@PEAPEAU2@W4SQLN 
N_BOOLEAN@@PEATsqlno_set@@@Z> <NotFound:-1> 
0000000010A13E90 000000000247BAF8 0000000000000000 
000007FE508803F0 0000000000000000 00000000026AAC20 offset: 
000000000000007E in 
<?sqlno_post_order_near_normalize@@YAHPEAUsqlno_globals@@PEAUsql 
no_plan_properties@@PEAUsqlno_order_class@@PEAPEAU3@@Z> 
<NotFound:-1> 
0000000010A13E98 0000000039800F0D 000007FE508803F0 
0000000000000000 00000000026AAC20 000007FE6443CDA0 offset: 
000000000000D037 in <sqlnoSmpPostPassMain> <NotFound:-1> 
 
 
This situation might happen under one of the following 
circumstances: 
 
- database manager has INTRA_PARALLEL ON and MAX_QUERY_DEGREE is 
greater then 1 or is ANY. 
- The CURRENT QUERY DEGREE special register is greater then 1 or 
is ANY 
- the query involves an OLAP function with a partition by clause 
fully covering the unique key columns of a table or the unique 
keys of several table which are joined together to preserve all 
the keys 
- all the key columns referenced in the partition by of the OLAP 
function are bound to local predicates.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to  DB2 UDB Version 9.7 FixPack 9                    * 
****************************************************************

Turn off  intra_partition parallelism: 
db2 update dbm cfg using INTRA_PARALLEL  NO 
and restart the instance. 
 
OR 
 
set CURRENT QUERY DEGREE 1 for the affected queries

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 UDB Version 9.7 FixPack 9

Turn off  intra_partition parallelism: 
db2 update dbm cfg using INTRA_PARALLEL  NO 
and restart the instance. 
 
OR 
 
set CURRENT QUERY DEGREE 1 for the affected queries

forerunner  : APAR is sysrouted TO one or more of the following: IC91848 IC95246 IT06759 
follow-up : 

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

14.04.2013
17.12.2013
17.12.2013

9.7.FP9