New version of utils2_ak
Posted in 2009
Friends, The latest release of my utils2_ak package has been uploaded to both the Oninit web site (www.oninit.com/utils) and the IIUG Software Repository ( www.iiug.org/software). The most significant new feature is in dostats: Dostats: New features: --procedure - creates a stored procedure to execute the UPDATE STATISTICS commands that dostats produces. --schedule - Schedule the stored procedure to run periodically or once using the 11.xx+ task scheduler feature. --aus-thresholds - Retrieve the Auto Update Statistics threshold settings to configure Aging, Browsing and PDQPRIORITY if enabled. This new feature gives you all of the benefits of using Auto Update Statistics (AUS) plus all of the features of dostats including more precise data distribution generation than AUS generates. If you schedule your dostats runs in cron - or in the IDS task scheduler using a stored procedure to execute dostats - passing your own procedure name with --procedure and --one-time, then dostats can now be a complete superset replacement for AUS. Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.