|
Problem IT03481
|
Status: Closed |
WHEN THE NUMBER OF PREDICATES IN A FEDERATED QUERY HAS BEEN EXCEEDED, SQL0430 IS RETURNED. |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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 |
| Solution |
First fixed in DB2 v10.5 FixPack 5. |
| Workaround |
See LOCAL FIX. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 30.07.2014
01.04.2015
15.07.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.5
|
 |
