|
Problem IT03481
|
Status: Geschlossen |
WHEN THE NUMBER OF PREDICATES IN A FEDERATED QUERY HAS BEEN EXCEEDED, SQL0430 IS RETURNED. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A50 - 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: *
* Upgraded to DB2 v10.5 Fixpack 5. This is a server side fix *
* which should be applied to the Federated server. *
**************************************************************** |
| 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 DB2 v10.5 FixPack 5. |
| Workaround |
See LOCAL FIX. |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 30.07.2014
01.04.2015
15.07.2015 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.5.0.5
|
 |
