Re: sqlexec problem on large join

Hi Jonathan, Thanks! The query succeeds if I copy the table from the other database instance into the local instance. So, that conclusively proves that it is networking problem. I guess I have the solution for now. Please let me know if you get any insight into this networking problem. -Anand- In article <37799C69.8F@earthlink.net>, jleffler@earthlink.net wrote: > anand_gupta@my-deja.com wrote: > > On a sql query which does a join across the two database > > instance I get following error message, > > > > Exception: Invalid memory address (dce / thd) > > 408: Invalid message type received from sqlexec process.> > > > The informix version running the two database instances are > > 5.02 and 4.11. > > > > The query involves large amount of data. How should I go > > about investigating this problem. > > Well, it shouldn't happen. However, both versions are very archaic > and you should probably start by upgrading to 5.10 for both machines. > > I'm not sure that there's very much else you can do, to be quite > honest. You could demonstrate that it is a networking problem (or > not) by copying one table to the other database and then running the > local-only query. Where you go after that is far from obvious. > > -- > Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) > Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN > #include <disclaimer.h> > > Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.