Re: Update Statistics, Error -647

contact TS > Is it standard behavior that update statistics session cannot be killed? no, it sounds like this session is gone walkabout. Superboer. Habichtsberg, Reinhard schreef: > 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.