Re: Problem with set explain on

Sujit Pal wrote: > Helmut > > We had this same problem some time back with the SET DEBUG TO for Stored = > Procedures. Only user informix could create one. As per the advice of = > Informix tech support we reinstalled the software (Informix) and the = > problem went away. > > HTH > > Sujit > > snap ... If I run a "set explain on" by any user other than informix, I get theerror messages: 534: Cannot open EXPLAIN file 1: NOT OWNERIt is ok if I launch it by user informix. The access rights on the > snip Hi Sujit, Many thanks for your hint. It gave me the idea what to check. Some wally of the month had run a "chmod 777" on the whole Informix subtree (and I don't know where else). I was able to recreate the access rights without reinstalling Informix using the informations in $INFORMIXDIR/etc/onlinefiles. Thanks and regards Helmut Leininger Bull AG Unix Support Email: Helmut.Leininger@bull.net