Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
David Williams — — source: Informix-list mailing list archive (1991-1998)
In article <328A3FCF.2046@storm.nws.noaa.gov>, Mark Oberfield
<oberfiel@storm.nws.noaa.gov> writes
>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.
>
Recompile since the version of the Operating system has changed.
I doubt HP-UX 9.01 and HP-UX 10.1 are compatible.
> 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?
Have you tried doing an
onstat -
when the application is hung.
Also try onstat -u | grep <process id>
Also check you messages in the online.log
Also run netstat -i.
What are the results?
>
> TIA,
>
>mgo
--
David Williams
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.