|
Problem IC95221
|
Status: Closed |
INSTANCE PANIC WHEN AGGREGATION FUNCTION(IE.MIN,MAX,SUM...) IS USED AGAINST ROWID RESULT |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
Instance crashes with a signal #11 when an sql query is run that
uses aggregation functions such as MIN, MAX, SUM (or others),
and if the data being run through the aggregation function is
the result of the rowid function.
The following is the stack for the agent that trapped with the
signal:
Stack #1 Signal #11 Timestamp
2013-03-21-09.57.28.807597
0 ossDumpStackTraceInternal
1 ossDumpStackTraceV98
2 OSSTrapFile::dumpEx
3 sqlo_trce
4 sqloEDUCodeTrapHandler
5 __PRETTY_FUNCTION__.5884
6 __intel_ssse3_rep_memcpy
7 _intel_fast_memcpy.P
8 sqlrxcon_simple
9 sqlri_min_Complete_Varchar_ForBitData
10 sqlriag2
11 sqldEvalDataPred
12 sqlsEvalPred
13 sqlsfetc
14 sqlriFetch
15 sqlrita
16 sqlriSectInvoke
17 sqlrr_process_fetch_request
18 sqlrr_open
19 sqljs_ddm_opnqry
20 sqljsParseRdbAccessed
21 sqljsParse
22 sqljsSqlam
23 sqljsDriveRequests
24 sqljsDrdaAsInnerDriver
25 sqljsDrdaAsDriver
26 sqeAgent::RunEDU
27 sqzEDUObj::EDUDriver
28 sqlzRunEDU
29 sqloEDUEntry
30 pthread_timedjoin_np
31 clone |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to V10.5 Fixpack 3 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
Fixed in V10.5 Fixpack 3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.08.2013
27.02.2014
27.02.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
