RE: Kill Update Statistics
This is a discussion on RE: Kill Update Statistics within the Informix forums, part of the Database Server Software category; --> Sure, I tried with onmode <sesid> (not with onstat -z, was a typo) without any success. > -----Ursprüngliche Nachricht----- ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 05:28 PM
| ||||
| ||||
 RE: Kill Update Statistics Sure, I tried with onmode <sesid> (not with onstat -z, was a typo) without any success. > -----Ursprüngliche Nachricht----- > Von: informix-list-bounces@iiug.org > [mailto:informix-list-bounces@iiug.org]Im Auftrag von Martin Fuerderer > Gesendet am: Mittwoch, 17. Oktober 2007 15:43 > An: Habichtsberg, Reinhard > Cc: informix-list-bounces@iiug.org; Informix-List (E-Mail) > Betreff: Re: Kill Update Statistics > > 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 > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >      |
Linear Mode
