This is a discussion on Re: Kill Update Statistics within the Informix forums, part of the Database Server Software category; --> Hi, I think it should be "onmode -z <sesid>" (as user informix). "onstat -z" only zeroes internal statistic values ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi, I think it should be "onmode -z <sesid>" (as user informix). "onstat -z" only zeroes internal statistic values (like what is displayed by "onstat -p"), but it does not have an effect on running sessions. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management IBM Deutschland GmbH Chairman of the Supervisory Board: Hans Ulrich Märki Board of Management: Martin Jetter (Chairman), Rudolf Bauer, Christian Diedrich, Christoph Grandpierre, Matthias Hartmann, Thomas Fell, Michael Diemer Corporate Seat: Stuttgart, Germany; Reg.-Gericht: Amtsgericht Stuttgart, HRB-Nr.: 14 562 WEEE-Reg.-Nr. DE 99369940 informix-list-bounces@iiug.org wrote on 17.10.2007 14:05:24: > Is there any way to kill a running update statistics. > > UPDATE STATISTICS HIGH FOR TABLE foo (bar) DISTRIBUTIONS ONLY. > > I tried with with onstat -z several times but it runs and runs and seems to > do nothing anyway. > > Regards > Reinhard > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list |