Update Stats Error -647
Hi,
with IDS 11.50.FC3 on Solaris 9 it appears the following error:
490 UPDATE STATIST kva CR Not Wait -647 0 9.24
Off
Current SQL statement :
UPDATE STATISTICS MEDIUM FOR TABLE kva_efn_gonr (efg_lfd_pos,
efg_leist_dat, efg_leist_anz, efg_begruendung, efg_sachkostenbez,
efg_leist_dat_orig, efg_kz_extrabudget, efg_nbsnr_arzt, efg_lanr_arzt,
efg_fg_code) sampling size 0.3
Last parsed SQL statement :
UPDATE STATISTICS MEDIUM FOR TABLE kva_efn_gonr (efg_lfd_pos,
efg_leist_dat, efg_leist_anz, efg_begruendung, efg_sachkostenbez,
efg_leist_dat_orig, efg_kz_extrabudget, efg_nbsnr_arzt, efg_lanr_arzt,
efg_fg_code) sampling size 0.3
dbtest-db3_11:/home/informix/migration_auf_11.50/db3%finderr 647
-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.
Number of Rows 1,4878e09
Could be a bug with very large tables?
TIA,
Reinhard.