Update Statistics, Error -647

Posted in 2006

Habichtsberg, Reinhard — Wed, 28 Jun 2006 09:43:29 +0200 — source: Usenet: comp.databases.informix

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.

Related threads

Posting from the Informix-list
Migrating from IDS 9.40.UC6 to 11.50.UC3
Ip for a network session
questions onstat -g