|
Problem IC81368
|
Status: Closed |
DB2 MIGHT ABEND WHEN EXECUTING A EXISTENTIAL SUBQUERY INSIDE AN AGGREGATION FUNCTION. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All Platforms *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v9.7 Fixpack 6 or Higher *
**************************************************************** |
| Local Fix: |
|
| 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 |
Fixed in v9.7 Fixpack 6 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC84407
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.02.2012
17.07.2012
17.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
|
 |
