Re: DBSA question....

Joe Trubisz wrote: > > Hi... > > Another newbie Informix question... > > I tried to run a onstat - from a non-informix userid. > The command came back with a 'unable to use shared memory - permission denied' Sounds like this user does not have all of the required environment variables exported or even set. Most critical are ONCONFIG, INFORMIXDIR and INFORMIXSERVER for access to shared memory. Check the permissions on shared memory (ipcs | grep informix) they should be "-rw-rw-rw" so anyone has permissions. > > OK...why did I get this message first off? > > Secondly, is there a way in which I can make onstat for example be > available to all users? Or is this a DBSA thing only? Anyone can run onstat. It is normally available to all users. > > And...how do you make someone a DBSA? IS this different from a GRANT DBA > to a particular user? Only user informix and root have full permissions. Art S. Kagel