DB2 - Problem description
Problem IT05865 | Status: Closed |
UNREFERENCED UDF IN A CSE CAN LEAD TO DB2 ABEND | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
Under rare scenarios DB2 might abend if the following conditions are true: 1) The query references one or more common table expressions (CTE) or views 2) The view or CTE contains one or more UDFs in the output select list 3) The view or CTE is referenced in the query two or more times 4) No consumer of the CTE references the columns originating from the UDF. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * See SYSROUTE APARs to see where this APAR is addressed * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 02.12.2014 09.05.2017 09.05.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.5.0.7 |