|
Problem IT09947
|
Status: Closed |
WHEN THE NUMBER OF PREDICATES IN A FEDERATED QUERY HAS BEEN EXCEEDED, SQL0430 IS RETURNED. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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: *
* 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 |
| Solution |
First fixed in v9.7 Fix Pack 11 |
| Workaround |
See LOCAL FIX. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.07.2015
28.10.2015
28.10.2015 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP11
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.11
|
 |
