RE: Using dostats after upgrade to 9.2x in place

Hi Brian, Thanks for your message. I probably didn't make myself clear enough. I am logged in as 'informix' and 'informix' is the DBA for the said database - but I still get the -389 error message. I did receive the answer from Marco Greco <marco@informix.com> >>update sysprocedures set mode="O" where procname=" oldsystdist">> >>Where MODE = 'O' is owner priviledged, 'D' is DBA priviledged, and >>'P' is a system procedure, the point being that nobody (except for >>certain system processes - eg upgrades) can actually touch them. Previously the mode of ' oldsystdist' SP was 'P' Andy Jarman -----Original Message----- From: Brian Wilkins [mailto:brianw@informix.com] Sent: 22 September 2000 16:57 To: Jarman, Andy Cc: informix-list@iiug.org; 'Marco Greco' Subject: Re: Using dostats after upgrade to 9.2x in place I don't have a 9.2 instance that has been upgraded from 7 right to hand. You could try it as user informix, try it as the owner of the database, try it as the owner of the procedure, try it as a user who has DBA privileges on the database. Brian W. "Jarman, Andy" wrote: > Hi Brian, > > Marco beat you to the answer by about five minutes. Thanks guys. > > Unfortunately, although this environment variable allows me to send this > SQL statement to the engine, it returns "-389 No DBA permission.". But > 'informix' is the database owner ??? > > Any pointers ? > > Andy Jarman >