|
Problem IC71560
|
Status: Geschlossen |
"BINARY_REP" COLUMN OPTION FOR REMOTE INFORMIX BYTE DATA TYPE MAKES SQL FAILED |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
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 |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Federation Server *
****************************************************************
* PROBLEM DESCRIPTION: *
* Incorrect to pushdown informix column with BYTE data type. *
* The possible errorm message will be: *
* SQL1822N Unexpected error code "-615" received from data *
* source "INFODB". *
* Associated text and tokens are "Blobs are not allowed in *
* this expression.". *
* SQLSTATE=560BD *
* Return Status = 0 *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Federation server database version 9.7.0.4 *
**************************************************************** |
| Local-Fix: |
Delete the "BINARY_REP" column option |
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
Federation server database version 9.7.0.4 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 29.09.2010
31.01.2011
31.01.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.0.4
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.4
|
 |
