|
Problem IC91197
|
Status: Closed |
INSTANCE PANIC WHEN AGGREGATION FUNCTION(IE.MIN,MAX,SUM...) IS USED AGAINST ROWID RESULT |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - 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.1 Fixpack 3 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
Fixed in V10.1 Fixpack 3 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC95221
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 29.03.2013
14.10.2013
14.10.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
