DB2 FOR LUW / DB2FORLUW / 970 - DB2

Db2 might abend under the following scenario: 
 
1. The query has a group by 
2. The aggregate function in the select list has a reference to 
an existential subquery. 
 
Possible Return Code: 
 
SQL0901N  The SQL statement failed because of a non-severe 
system error. 
Subsequent SQL statements can be processed.  (Reason "Bad Plan; 
Unresolved QNC 
found".)  SQLSTATE=58004 
 
SQL1224N  The database manager is not able to accept new 
requests, has 
terminated all requests in progress, or has terminated the 
specified request 
because of an error or a forced interrupt.  SQLSTATE=55032 
 
Possible Stack: 
Stack #1 
0        ossDumpStackTraceEx 
1        OSSTrapFile::dumpEx 
2        sqlo_trce 
3        sqloEDUCodeTrapHandler 
4        __invoke_dynamic_linker__ 
5        sqlnq_qunqncchild::pp 
6        sqlno_outer_reference 
7        sqlnx_exp_process_correlated_col_info 
8        sqlnx_exp_FETCH_analyze 
9        sqlnx_exp_analyze_plan 
10       sqlnx_exp_analyze_plan 
11       sqlnx_exp_analyze_plan 
12       sqlnx_exp_analyze_plan 
13       sqlnx_exp_analyze_plan 
14       sqlnx_exp_analyze_plan 
15       sqlnx_exp_UNION_post 
16       sqlnx_exp_analyze_plan 
17       sqlnx_exp_analyze_plan 
18       sqlnx_exp_analyze_plan 
19       sqlnx_exp_analyze_plan 
20       sqlnx_exp_analyze_plan 
21       sqlnx_exp_analyze_plan 
22       sqlnx_exp_analyze_plan 
23       sqlnx_exp_analyze_plan 
24       sqlnx_explain_plan 
25       sqlnn_cmpl 
26       sqlnn_cmpl 
27       sqlra_compile_var 
28       sqlra_find_var 
29       sqlra_get_var 
30       sqlrr_prepare 
31       sqljs_ddm_prpsqlstt 
32       sqljsParseRdbAccessed 
33       sqljsParse 
34       sqljsSqlam 
35       sqljsDriveRequests 
36       sqljsDrdaAsInnerDriver 
37       sqljsDrdaAsDriver 
38       sqeAgent::RunEDU 
39       sqzEDUObj::EDUDriver 
40       sqlzRunEDU 
41       sqloEDUEntry 
42       pthread_cond_wait@@GLIBC_2.3.2 
43       clone

**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v9.7 Fixpack 6 or Higher                          * 
****************************************************************

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
 

Fixed in v9.7 Fixpack 6

keiner bekannt / siehe Local-Fix

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

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

13.02.2012
17.07.2012
17.07.2012

9.7.FP6