Update Statistics

Greetings. I have a few questions regarding using distributions with IDS. We're currently using IDS 7.30.UC6 on Solaris 2.6. I've used Informix's prescribed algorithm for updating statistics on a limited basis on our databases. I've been gun shy about using them across the board as I've heard of bugs with UPDATE STATS HIGH in the past and experienced problems. At one point Informix told us to not use distributions. I'm not sure what may be lurking out there yet. Here are my questions: 1) Have there been any problems using the Informix procedure for updating statistics? 2) Do I need to consider changing nextsize for SYSDISTRIB from the default? What factors determine the size of the sysdistrib table? 3) Are there any other resources to consider before using distributions on a large scale? 4) What disk space does the DBUPSPACE environmental variable refer to? I saw no answer for this in the Informix SQL ref. 5) Are there any guidelines for the setting of DBUPSPACE? 6) I've compiled and played with Art Kagel's dostats program. It looks extremely useful. Has anyone had any noteworthy experiences using dostats, either good or bad? Thanks for your thoughts on this. Dick Brieck , DBA Chase Manhattan Mortgage Corp