Re: Update Statistics

Robertson Lee NTSE wrote: > > All, > > I have been left a large script by the Informix DBA to run. It does an > update statistics (low, medium and high) on all of the tables in the db.> > Is there any way I can monitor how this is doing as at the moment it is just > sat in dbaccess and I can't tell how much progress is being made. > Do onstat -u to examine the user queue. Establish which is your UPDATE STATISTICS script ( if it's not obvious, do an onstat -g ses of likely candidates and examone the PID produced). onstat -g ses or onstat -g sql will then give you the SQL statement currently being executed. Neil Truby Chase Manhattan Bank Bournemouth, UK