Fixes are available
APAR status
Closed as program error.
Error description
Informix BYTE is a kind of LOB data type. With the "BINARY_REP" column option, the predicate related to this column may be pushed down to remote data source, which makes the SQL statement failed because Informix BYTE can't be directly compared or bound. The possible error message would be: SQL1822N Unexpected error code "-615" received from data source "InformixSer". Associated text and tokens are "Blobs are not allowed in this expression.". SQLSTATE=560BD Return Status = 0
Local fix
Delete the "BINARY_REP" column option
Problem summary
**************************************************************** * USERS AFFECTED: * * Federation server * **************************************************************** * PROBLEM DESCRIPTION: * * Informix BYTE is a kind of LOB data type. With the * * "BINARY_REP" column option, the predicate related to this * * column may be pushed down to remote data source, which makes * * the SQL statement failed because Informix BYTE can't be * * directly compared or bound. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 v9.5.0.7 * ****************************************************************
Problem conclusion
The problem is fixed in DB2 v9.5.0.7
Temporary fix
Comments
APAR Information
APAR number
JR37872
Reported component name
FEDERATION SERV
Reported component ID
5724N9700
Reported release
950
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-09-28
Closed date
2010-10-25
Last modified date
2010-10-25
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
IC71560 IC71561
Fix information
Fixed component name
FEDERATION SERV
Fixed component ID
5724N9700
Applicable component levels
R950 PSN
UP
R950 PSY
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCAVPY","label":"General Issues"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.5","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
25 October 2010