AW: Update Statistics, Error -647

Hi, did as you suggested but update statistics drop distributions last very long. So, I'm waiting on ... Thx, Reinhard. > -----Ursprüngliche Nachricht----- > Von: Tsutomu Ogiwara [mailto:tsutomu_ogiwara@hotmail.com] > Gesendet am: Donnerstag, 29. Juni 2006 04:21 > An: RHabichtsberg@arz-emmendingen.de; informix-list@iiug.org > Betreff: RE: Update Statistics, Error -647 > > Hi, > > Just a thought. > > Execute "update statistics drop distributions" via dbaccess or etc. > Then execute "update statistics", again. > > Just my $0.02. > > -- > Tsutomu Ogiwara from Tokyo Japan. > > > > > > >From: "Habichtsberg, Reinhard" <RHabichtsberg@arz-emmendingen.de> > >To: "Informix-List (E-Mail)" <informix-list@iiug.org> > >Subject: Update Statistics, Error -647 > >Date: Wed, 28 Jun 2006 09:43:29 +0200 > > > >IDS 9.40 FC4W2 > >Solaris 9 > > > >Two questions about update statistics: > >1. onstat -g sid reports: > > 761708 UPDATE STATIST aze CR Not Wait -647 0 > >9.03 Off > > Current SQL statement : > > update statistics medium> > > > finderr 647: Error evaluating math library function > function-name > > The data type of the argument is correct, but the value > passed to > >the > > function is not appropriate for the math function. > Check that you > >are > > passing a legitimate value to the function. > > > > The session is running and causes some workload. > > > > I have no idea of the reason and implications of that error. Any > >suggestions? > > > >2. I cannot kill sessions which are running update > statistics with onmode > >-z > >sid. Also killing the calling unix process has no effect. > >Is it standard behavior that update statistics session > cannot be killed? > > > >TIA, > >Reinhard. > > > >_______________________________________________ > >Informix-list mailing list > >Informix-list@iiug.org > >http://www.iiug.org/mailman/listinfo/informix-list > >