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