Greetings,
We have a large set of applications which use ESQL/C and
Informix 5.03 Online on an HP 9.01 system successfully.
We have transferred these applications (no recompilations)
to another HP system (ver 10.1) with Informix 7.11.
A problem has appeared with tables containing a large
number of BLOB columns (~80 columns). Creating the
blobspaces on the new system and exporting the databases
from ver 5.03 to 7.11 went fine. Oncheck -cD on the new
tables did not find any problems.
Specifically the problem occurs when applications try
to fetch data out of the blob columns. The result is
very sporatic (sp) -- a few times it works, but most of the
time the applications just "hangs" when trying to fetch
the data out of the blob columns. We can successfully
fetch data out of "non-blob" columns.
We can unload the offending blob columns via dbaccess
normally.
If it is a bug in the 7.11 relay module (SQLRM) and the only
solution availible is that we have to recompile our ESQL
library routines and relink our applications against the
new library, fine. But I was hoping that a suggestion
or two from you INFORMIX genuses (or regular guys/gals ;-))
out there would save us a week's worth of recompilations.
Any ideas?
TIA,
mgo
--
--------------------------------------------------------------
Mark Oberfield SSMC2, W/OSD25
Rm 10126
Silver Spring,MD 20910
--------------------------------------------------------------