|
Problem IT06404
|
Status: Closed |
QUERY FAILURE DUE TO VIEW OR COMMON TABLE REFERENCED MULTIPLE TI MES AND NESTED FUNCTION TEMPLATE CALLS IN QUERY WITH IMPLEMENTAT |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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: |
|
| Solution |
First fixed in DB2 V10.1 Fix Pack 5. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.01.2015
21.07.2015
21.07.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.5
|
 |
