DB2 FOR LUW / DB2FORLUW / A10 - 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 10.1 Fix Pack 3                  * 
****************************************************************

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 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
 

Problem was first fixed in DB2 UDB Version 10.1 Fix Pack 3

not known / see Local fix

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

24.04.2013
21.10.2013
21.10.2013