Re: Update Statistics

Robertson Lee NTSE wrote in message <6fft5q$cus$1@news.xmission.com>... > >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. > >Informix 7.23 UC10 >HP-UX 10.01 Using another terminal or session, run onstat -g sql and identify the session that is running update statistics then run onstat -g sql # where # is the session no you just identified. The result will tell you which bit of sql was executed last, and hence how far thru the script you have got. That is as good as it gets.