Answer to SET EXPLAIN: Error -534

I have the database set to start when the machine boots. At this time, it is started by 'root'. On a suggestion by David Kleppinger, I bring it down and back up, only this time as 'informix', and voila, it works. I thank all of you for your thoughts, precious time and involvement. Sent via Deja.com http://www.deja.com/ Before you buy.

This is not good solution. SET EXPLAIN (and everything else) must work in the same way when root strats engine. I think the reason is in ownership of ONINIT file. So: ls -l oninit have to produce: -rwsr-sr-- 1 root informix 4654164 Oct 24 1997 oninit On Thu, 17 Aug 2000 03:55:41 GMT, R Srinivasan <euroinvestor@yahoo.com> wrote: >I have the database set to start when the machine boots. At this time, >it is started by 'root'. On a suggestion by David Kleppinger, I bring >it down and back up, only this time as 'informix', and voila, it works. >I thank all of you for your thoughts, precious time and involvement. > > >Sent via Deja.com http://www.deja.com/ >Before you buy.

When you startup use the su command, ie su - informix -c oninit I think is the syntax. see man su "remove (_at_) to reply" <mips_at_@zg.tel.hr> wrote in message news:aaumpsgl1lpjkprtelgl3et5o128ndrvdd@4ax.com... > This is not good solution. SET EXPLAIN (and everything else) must work in the > same way when root strats engine. I think the reason is in ownership of ONINIT > file. So: > ls -l oninit > > have to produce: > -rwsr-sr-- 1 root informix 4654164 Oct 24 1997 oninit > > On Thu, 17 Aug 2000 03:55:41 GMT, R Srinivasan <euroinvestor@yahoo.com> wrote: > > >I have the database set to start when the machine boots. At this time, > >it is started by 'root'. On a suggestion by David Kleppinger, I bring > >it down and back up, only this time as 'informix', and voila, it works. > >I thank all of you for your thoughts, precious time and involvement. > > > > > >Sent via Deja.com http://www.deja.com/ > >Before you buy. >