|
Problem IC91197
|
Status: Geschlossen |
INSTANCE PANIC WHEN AGGREGATION FUNCTION(IE.MIN,MAX,SUM...) IS USED AGAINST ROWID RESULT |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to V10.1 Fixpack 3 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
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
|
| Lösung |
Fixed in V10.1 Fixpack 3 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC95221
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 29.03.2013
14.10.2013
14.10.2013 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
