Fixes are available
APAR status
Closed as program error.
Error description
The federated query not completely pushed down to the host when the parameter markers are used. The problem does not reproduce if the the same query is hardcoded.
Local fix
The problem can be worked around by casting the data type of the parameter markers, e.g. CAST (? as varchar(n)) (n<255).
Problem summary
Users affected: Users of the Informix wrapper in the DB2 for LUW Homogeneous Federation Feature or InfoSphere Federation Server Problem description and summary: See error description.
Problem conclusion
Problem was first fixed in Version 9.1 FixPak 9 (s100326 ). This fix should be applied on the federation server.
Temporary fix
Comments
APAR Information
APAR number
JR32392
Reported component name
INFORMIX WRAPPE
Reported component ID
5724N9710
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-03-17
Closed date
2010-04-14
Last modified date
2010-04-14
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
INFORMIX WRAPPE
Fixed component ID
5724N9710
Applicable component levels
R910 PSN
UP
R911 PSN
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCAVPK","label":"Data Sources and Wrappers - Informix"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
14 April 2010