DB2 - Problembeschreibung
Problem IT09947 | Status: Geschlossen |
WHEN THE NUMBER OF PREDICATES IN A FEDERATED QUERY HAS BEEN EXCEEDED, SQL0430 IS RETURNED. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
When the number of predicates in a Federated query has been exceeded, SQL0430 is returned because the Federated User Defined Function (UDF) has abnormally terminated. This APAR increases the maximum number of predicates permitted in a Federated SQL query. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Federated * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade server to v9.7 Fixpack 11 * **************************************************************** | |
Local-Fix: | |
Disable statement concentrator by setting DB CFG parameter STMT_CONC=OFF http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.1.0/com. ibm.db2.luw.admin.config.doc/doc/r0054239.html?cp=SSEPGG_10.1.0% 2F2-2-4-8-129&lang=en | |
Lösung | |
First fixed in v9.7 Fix Pack 11 | |
Workaround | |
See LOCAL FIX. | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 09.07.2015 28.10.2015 28.10.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP11 | |
Problem behoben lt. FixList in der Version | |
9.7.0.11 |