Re: Ver 5.03 client to Ver 7.11 server problem.

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