|
Problem IC73512
|
Status: Geschlossen |
DB MAY ABEND WHILE EXECUTING AN OLAP QUERY WITH A BOUNDED WINDOW AGGREGATION RANGE GROUPING. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problembeschreibung: |
The database may abend when an OLAP query is executed:
The query must have the following:
1. Be a Range window grouping
2. The range must be bounded
3. There must be an order by clause as part of scalar
aggregation
The stack trace observed is as follows:
<stacktrace>
sqlng_build_SCALAG_op
sqlng_process_mate_op
sqlng_process_pipe_op
sqlng_process_mate_op
sqlng_process_pipe_op
sqlng_process_return_op
sqlng_build_thread
sqlng_main
sqlnn_cmpl
....
</stacktrace> |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* V95fp7 *
****************************************************************
* PROBLEM DESCRIPTION: *
* The database may abend when an OLAP query is executed: *
* *
* The query must have the following: *
* *
* 1. Be a Range window grouping *
* *
* 2. The range must be bounded *
* *
* 3. There must be an order by clause as part of scalar *
* *
* aggregation *
* *
* *
* *
* The stack trace observed is as follows: *
* *
* <stacktrace> *
* *
* *
* *
* sqlng_build_SCALAG_op *
* *
* sqlng_process_mate_op *
* *
* sqlng_process_pipe_op *
* *
* sqlng_process_mate_op *
* *
* sqlng_process_pipe_op *
* *
* sqlng_process_return_op *
* *
* sqlng_build_thread *
* *
* *
* *
* sqlng_main *
* *
* sqlnn_cmpl *
* *
* .... *
* *
* </stacktrace> *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v95fp8 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
Program defect |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC73541 IC73569
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 27.12.2010
05.07.2011
05.07.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.5.FP8
|
| Problem behoben lt. FixList in der Version |
| 9.5.0.8
|
 |
