RE: Distributions and dostats

I've been using 'dostats' for several months now -- works great! I have 7.2x and 7.3x running on HP-UX 10.20 boxes. No problems. :-) > -----Original Message----- > From: Dick.Brieck@chase.com [mailto:Dick.Brieck@chase.com] > Sent: Monday, November 22, 1999 1:38 PM > To: informix-list@iiug.org > Subject: Distributions and dostats > > > > > 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 > >