Kill Update Statistics
This is a discussion on Kill Update Statistics within the Informix forums, part of the Database Server Software category; --> Is there any way to kill a running update statistics. UPDATE STATISTICS HIGH FOR TABLE foo (bar) DISTRIBUTIONS ONLY. ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 05:28 PM
| |||
| |||
 Re: Kill Update Statistics On Oct 17, 8:05 am, "Habichtsberg, Reinhard" <RHabichtsb...@arz- emmendingen.de> wrote: > 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. I concur with DL, there's no way to kill a running UPDATE STATISTICS thread. Art S. Kagel      |
|
04-20-2008, 05:29 PM
| |||
| |||
| Re: Kill Update Statistics On 17 Oct, 16:31, "Art S. Kagel" <art.ka...@gmail.com> wrote: > On Oct 17, 8:05 am, "Habichtsberg, Reinhard" <RHabichtsb...@arz- > > emmendingen.de> wrote: > > 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. > > I concur with DL, there's no way to kill a running UPDATE STATISTICS > thread. > > Art S. Kagel Why not? What is the stack for the thread? Is it in a critical section otherwise that is a bug that needs to be reported to IBM. David. |
|
04-20-2008, 05:29 PM
| ||||
| ||||
| Re: Kill Update Statistics On Oct 24, 2:29 pm, "da...@smooth1.co.uk" <da...@smooth1.co.uk> wrote: > On 17 Oct, 16:31, "Art S. Kagel" <art.ka...@gmail.com> wrote: > > > On Oct 17, 8:05 am, "Habichtsberg, Reinhard" <RHabichtsb...@arz- > > > emmendingen.de> wrote: > > > 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. > > > I concur with DL, there's no way to kill a running UPDATE STATISTICS > > thread. > > > Art S. Kagel > > Why not? What is the stack for the thread? Is it in a critical section > otherwise that is a bug that needs to be reported to IBM. It's apparently in some kind of critical section because it dies eventually if you kill the client task or onmode -z the session and usually it rolls back. You'd have to ask John Miller why it works that way and if it's WAD. Art S. Kagel > David. |
Linear Mode
