|
Problem IT06404
|
Status: Geschlossen |
QUERY FAILURE DUE TO VIEW OR COMMON TABLE REFERENCED MULTIPLE TI MES AND NESTED FUNCTION TEMPLATE CALLS IN QUERY WITH IMPLEMENTAT |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problembeschreibung: |
The issue occurs when a view or common table is referenced
multiple times in the query and there is are nested function
template calls in the SQL statement with implementations on more
then 1 remote server. In this case
A_PG$ABC_WW.Add_ww(A_PG$ABC_WW.Calculate_ww(SYSDATE), -1)
In some circumstances the function templates are not pushed down
to the remote servers and DB2 is unable to execute the query.
This results in the SQL0142 that was observed by our customer. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All DB2 V10.1 Users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V10.1 Fix Pack 5 or higher. *
**************************************************************** |
| Local-Fix: |
|
| Lösung |
First fixed in DB2 V10.1 Fix Pack 5. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 09.01.2015
21.07.2015
21.07.2015 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.5
|
 |
