dostats - IDS 11.50

We have been using the dostats utility for years successfully with our IDS 10 environment. In September we are upgrading to 11.50. Is dostats supported against 11.50? If not, does this mean it won't work? I know that IDS 11.xx has the ability to auto update stats. However, I would feel more comfortable using the dostats utility initially, until the system has had time to settle. Any advise or help on this appreciated. Andrew Clark

Yes, IDS 11.50 supports the dostats utility. In fact, we have shut off the AUS and opted to use our own scripts that update statistics using Art's dostats. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of ANDREW CLARK Sent: Wednesday, August 11, 2010 11:11 AM To: ids@iiug.org Subject: dostats - IDS 11.50 [20842] We have been using the dostats utility for years successfully with our IDS 10 environment. In September we are upgrading to 11.50. Is dostats supported against 11.50? If not, does this mean it won't work? I know that IDS 11.xx has the ability to auto update stats. However, I would feel more comfortable using the dostats utility initially, until the system has had time to settle. Any advise or help on this appreciated. Andrew Clark ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Yesssssssssss We did the same here, on our 11.50 instances, mainly because the paralel running feature of dostats, that speeds up several times over AUS. Regards. Em 11/08/2010 12:18, Plugge, Joe R. escreveu: > Yes, IDS 11.50 supports the dostats utility. In fact, we have shut off the AUS > and opted to use our own scripts that update statistics using Art's dostats. > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of ANDREW > CLARK > Sent: Wednesday, August 11, 2010 11:11 AM > To: ids@iiug.org > Subject: dostats - IDS 11.50 [20842] > > We have been using the dostats utility for years successfully with our IDS 10 > environment. In September we are upgrading to 11.50. Is dostats supported > against 11.50? If not, does this mean it won't work? I know that IDS 11.xx has > the ability to auto update stats. However, I would feel more comfortable using > the dostats utility initially, until the system has had time to settle. Any > advise or help on this appreciated. > > Andrew Clark > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Alexandre Marini Tecnologia da Informação - DBA msn: alexandre_marini@hotmail.com SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix Cert-Info-Mgmt_color <Cert-Info-Mgmt_color.jpg> IBM Informix Dynamic Server Certified Professional V10 / V11

Andrew: Dostats will work with 11.50, indeed the latest release has the ability to replace AUS if you want. The new version of dostats, dostats_ng.ec, has new options that will permit it to run in the same mode as the AUS Evaluator run and schedule an update run to execute the stored procedure that it outputs sometime later, either once or periodically, if you give the stored procedure a specific name. Alternatively, you can set up your own periodic Update Statistics Run that executes a particular stored procedure at a giventime and then have the evaluator mode create that procedure. The relevant new options are: --schedule - Create a stored procedure with the commands and schedule the procedure to run in the future. --procedure - Create the named procedure with the UPDATE STATISTICS commands to run. Can be used to replace a previously scheduled command procedure, to create a new named procedure for scheduling or just to create a procedure to be manually executed later. --aus-thresholds - Retrieve the Auto Update Statistics settings for Aging, Browsing (Change), and PDQPRIORITY. This allows you to continue to use OAT to configure how update statistics is run if you are replacing AUS with dostats_ng. Personally, I continue to use dostats/dostats_ng at all of my client sites. It's evaluation methods put far less stress on the engine than the AUS Evaluator runs does in my experience and runs faster as well. At home I used --schedule with --procedure to create a proc that runs daily and have disabled AUS altogether. At most client sites, we continue to run dostats or dostats_ng out of cron and have disabled all delivered tasks in the task manager or have created a "stop file" to disable the task manager altogether in order to eliminate the overhead of AUS and the built-in sensors and the IO overhead they add to a system. Art Art S. Kagel Advanced DataTools (www.advancedatatools.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, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Aug 11, 2010 at 12:10 PM, ANDREW CLARK < aclark@infinityhealthcare.com> wrote: > We have been using the dostats utility for years successfully with our IDS > 10 > environment. In September we are upgrading to 11.50. Is dostats supported > against 11.50? If not, does this mean it won't work? I know that IDS 11.xx > has > the ability to auto update stats. However, I would feel more comfortable > using > the dostats utility initially, until the system has had time to settle. Any > advise or help on this appreciated. > > Andrew Clark > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636e1ef44aeb9d3048d8ed333