Oninit cdi / Archive
Talk to an expert →

Re: Kill Update Statistics

Posted in 2007

DL Redden — — source: Usenet: comp.databases.informix

You cannot kill a running UPDATE STATISTICS statement. It will run to completion. I'm don't know why, I just know you can't. ----- Original Message ---- From: "Habichtsberg, Reinhard" <RHabichtsberg@arz-emmendingen.de> To: Informix-List (E-Mail) <informix-list@iiug.org>; Martin Fuerderer <MARTINFU@de.ibm.com> Sent: Wednesday, October 17, 2007 8:51:39 AM Subject: 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 > _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list

Related threads