Re: SET EXPLAIN ON problem

In article <3d4rpo$5dg@athos.cc.bellcore.com> foxj@moscow.cc.bellcore.com (fox,james p) writes: > Hi, > We're currently having a problem with INFORMIX On-line Release 6.01 on > Pyramid. When we do a "SET EXPLAIN ON" in ISQL or ESQL/C we get > the following message: > > 534: Cannot open EXPLAIN output file. > 130: ISAM error: no such dbspace> > The home directory is writable and there is space. Hi Jim, although it might sound strange, but check your SHELL environment variable: If it either points to nothing or to an invalid Unix shell you will run into this error message. Try to do an unsetenv SHELL (for csh). I definitely have to admit that the error message is misleading... :-) Explanation: For some reason the 6.00 server is trying to fork a subshell in order to create the sqexplain.out file. If SHELL is not set correctly, you will run into trouble. Greetings from a cold and snowy Munich, Alexander PS.: If my hint doesn't help, you may have found a new problem... :-( -- Alexander Koerner @ Informix Germany Oskar-Messter-Str. 25, 85737 Ismaning Tel.: +49 89 960 980 Fax: +49 89 960 98 500 Email: alexk@informix.com (NeXTmail accepted!)