DB2 - Problembeschreibung
Problem IC66004 | Status: Geschlossen |
QUERY WITH AN UNREFERENCED COMMON TABLE EXPRESSION WHICH REFEREN CES AN SQL TRANSFORM FUNCTIONS MAY TERMINATE ABNORMALLY | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
DB2 may terminate abnormally when a query with a Common Table Expression (CTE) satisfies all of the following conditions: 1. an SQL scalar function is referenced in the query, 2. the subquery in the CTE requires the compilation of an SQL transform function, 3. the CTE mentioned in step 2 is not referenced anywhere in the query. -------Frame------ ------Function + Offset------ 0x09000000263D7B50 sqlns_expand_sql_fncs_in_opr__FP9sqlnq_oprP3loc + 0xEF0 0x09000000263D9444 sqlns_expand_sql_fncs_in_qur__FP9sqlnq_qurP3loc + 0x464 0x0900000026396B58 sqlns_qgs__FP9sqlnq_qur17sqlnq_requestTypePc + 0x818 0x090000002633BC64 sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq lrr_cmpl_enviT7PP9sqlnq_qur + 0x5C84 0x090000002633E664 sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq lrr_cmpl_env + 0x64 .... | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See problem description above * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.5 Fix Pack 6 * **************************************************************** | |
Local-Fix: | |
1. remove the unreferenced CTE from the query, or 2. add a reference to the CTE in the query. | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 Version 9.5 Fix Pack 6 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC66128 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 02.02.2010 19.07.2010 14.07.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP6 | |
Problem behoben lt. FixList in der Version |