Re: Lock Timeouts - Help needed

Irwin Goldstein wrote: > > James McCallum <james.mccallum@bradford.gov.uk> wrote in article > <6slvjg$evj$1@newsreader1.core.theplanet.net>... [SNIP] > A simple global "update statistics" will probably not yield the best > possible performance. Check out http://www.objectsoft.com for a a shell > script which does one of the Informix recommended sequences of update > statistics commands. I believe there is also an ESQL/C version of > something similar in the IIUG archives. The program is dostats.ec and is found in the submission named: utils2_ak submitted by me. There is a new version waiting in the wings that adds support for UPDATE STATISTICS FOR PROCEDURE... I will upload the update in a week or two after testing. By default dostats performs the recommended set of UPDATE STATs commands per the IDS 7.21 release notes with many options to adjust this behavior. The defaults are optimal for most tables/databases. Art S. Kagel