|
Problem IT10848
|
Status: Geschlossen |
HANG FOR QUERIES REFERENCING AT LEAST ONE COLUMN ORGANIZED TABLE AND WHEN THE QUERY CONTAINS AN EXORBITANT NUMBER OF OLAP FUNCTI |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problembeschreibung: |
Sometimes queries may hang if those queries are referencing at
least one Column organized table and when the query contains an
exorbitant number of OLAP functions with incompatible partition
by and sort requirements.
Symptom will be noticed by the application becoming stuck in
compile state and unable to be forced off.
The application will have the following function repeating in
the stack dump, for example:
<StackTrace>
sqlnq_qtb20descendant_qtb_recurEPS_i
sqlnq_qtb20descendant_qtb_recurEPS_i
sqlnq_qtb20descendant_qtb_recurEPS_i
sqlnq_qtb20descendant_qtb_recurEPS_i
sqlnq_qtb20descendant_qtb_recurEPS_i
etc. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 10.5 FP7 *
**************************************************************** |
| Local-Fix: |
|
| Lösung |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 21.08.2015
20.01.2016
20.01.2016 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.5.0.7
|
 |
