Informix - Problem description
Problem IT11909 | Status: Closed |
ON HDR SECONDARY, SELECT INTO TEMP WITH NO LOG ON BLOB COLUMN OFLENGTH 0 (BUT IS NOT SET TO NULL) RETURNS -618 AND -140 | |
product: | |
INFORMIX SERVER / 5725A3900 / B50 - IDS 11.50 | |
Problem description: | |
On HDR secondary, when a select into temp with no log is run on a TEXT or BYTE column with a size of 0, it returns error - 618 and ISAM -140. Example: > select * from test into temp tab1 with no log; 618: Error occurred while trying to copy TEXT or BYTE data. ISAM error: operation illegal on a DR Secondary and online.log shows following message: ERROR:closing remote partition blob | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Those using blobs on secondaries * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 11.70.xC9 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 21.10.2015 09.06.2017 09.06.2017 |
Problem solved at the following versions (IBM BugInfos) | |
11.70.xC9 | |
Problem solved according to the fixlist(s) of the following version(s) |