Re: SET EXPLAIN: Error -534

From: R Srinivasan <euroinvestor@yahoo.com> > >And you would be absolutely correct, Sir. Don't ask me why. I really >don't know. But it works when the database is started as >user 'informix'. Thank you. I love you guys. The power of the Internet. Are the permissions on your oninit -rwsr-s--- root informix ? >In article <399B0D3D.661CA5D4@dts.edu>, > dkleppinger@dts.edu wrote: > > R Srinivasan wrote: > > > > > > -Current directory has "drwxrwxrwx" permissions. So I don't think >that > > > would be the problem. Also, this used to work. > > > -And I don't remember changing anything. Haven't messed with > > > permissions on the Informix binaries. > > > -I don't have a temp dbspace set, as someone suggested. So I guess >I'll > > > have to try that. > > > - I also tried a) removing sqexplain.out and b) creating a zero- >length > > > file with "-rwxrwxrwx" permissions. > > > -SET EXPLAIN does work when I'm user 'informix', though. > > > > I say a report once that said this happens/doesn't happen depending on > > whether you started the engine as informix or root. > > -- > > +----------------------------------------------------------+ > > David Kleppinger > > Assoc. Dir. of Admin. Computing > > Dallas Theological Seminary > > +----------------------------------------------------------+ > > > > >Sent via Deja.com http://www.deja.com/ >Before you buy. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com