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
>