OAT and AUS (Auto Update Statistics)
Question: can OAT's Auto Update Statistics (AUS) be given a default RESOLUTION/confidence factor, and how do AUS-generated UPDATE STATISTICS commands differ from IBM's seeding script? John Miller (IBM) answered that AUS reuses whatever confidence, resolution and sample size were last used on a table, so you simply run UPDATE STATISTICS once manually at the desired resolution; he also suggested using the newer SAMPLING SIZE option instead of confidence. Art Kagel noted his dostats utility can do the evaluation and schedule stats runs via the IDS scheduler for those not using OAT. The question about specific AUS-vs-script differences went unanswered.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Is there a way within OAT to state a default RESOLUTION and confidence factor within AUS? Art, You mentioned there was a difference between UPDATE STATISTICS commands AUS generates vs. what the the seeding script (located at http://www-01.ibm.com/support/docview.wss?uid=swg21137764 generates. Other than (possibly) the aforementioned resolution/confidence factors, what are those differences? And are there plans underway to remedy those differences within OAT? Thanks in advance. Clifton _________________________________________________________________ Hotmail: Trusted email with Microsoft's powerful SPAM protection. http://clk.atdmt.com/GBL/go/177141664/direct/01/ http://clk.atdmt.com/GBL/go/177141664/direct/01/
AUS will use confidence, resolution & sample size which was previously run on the table. So just run the tables once for which you would like to have high resolutions. As for confidence, I would probably suggest that you use the new SAMPLING SIZE options as I think it will be a more meaningful to DBA and application programmers than confidence. John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 11/04/2009 11:51:44 AM: > [image removed] > > OAT and AUS (Auto Update Statistics) [17912] > > Clifton Bean > > to: > > ids > > 11/04/2009 11:52 AM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > Is there a way within OAT to state a default RESOLUTION and confidence factor > within AUS? > > Art, > > You mentioned there was a difference between UPDATE STATISTICS commands AUS > generates vs. what the the seeding script (located at > > http://www-01.ibm.com/support/docview.wss?uid=swg21137764 generates. Other > than (possibly) the aforementioned resolution/confidence factors, what are > those differences? And are there plans underway to remedy those differences > within OAT? > > Thanks in advance. > Clifton > > _________________________________________________________________ > Hotmail: Trusted email with Microsoft's powerful SPAM protection. > http://clk.atdmt.com/GBL/go/177141664/direct/01/ > http://clk.atdmt.com/GBL/go/177141664/direct/01/ > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
Has anyone written a script that will build the things for AUS ... if one doesn't want to use OAT? Peter Logan Senior Database Administrator Phone: 616/878-8309 From: "Clifton Bean" <clifton_bean@hotmail.com> To: ids@iiug.org Date: 11/04/2009 02:52 PM Subject: OAT and AUS (Auto Update Statistics) [17912] Sent by: ids-bounces@iiug.org Is there a way within OAT to state a default RESOLUTION and confidence factor within AUS? Art, You mentioned there was a difference between UPDATE STATISTICS commands AUS generates vs. what the the seeding script (located at http://www-01.ibm.com/support/docview.wss?uid=swg21137764 generates. Other than (possibly) the aforementioned resolution/confidence factors, what are those differences? And are there plans underway to remedy those differences within OAT? Thanks in advance. Clifton _________________________________________________________________ Hotmail: Trusted email with Microsoft's powerful SPAM protection. http://clk.atdmt.com/GBL/go/177141664/direct/01/ http://clk.atdmt.com/GBL/go/177141664/direct/01/ ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
The latest release of dostats can schedule the stats run the same as AUS does to run later using the IDS scheduler. The dostats run does the equivalent of the AUD evaluation phase and schedules the actual run for later as you specify on the commandline. Is that what you are looking for? Art 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. On Wed, Nov 4, 2009 at 3:25 PM, Peter_Logan@spartanstores.com < Peter_Logan@spartanstores.com> wrote: > Has anyone written a script that will build the things for AUS ... if one > doesn't want to use OAT? > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > > From: > "Clifton Bean" <clifton_bean@hotmail.com> > To: > ids@iiug.org > Date: > 11/04/2009 02:52 PM > Subject: > OAT and AUS (Auto Update Statistics) [17912] > Sent by: > ids-bounces@iiug.org > > Is there a way within OAT to state a default RESOLUTION and confidence > factor > within AUS? > > Art, > > You mentioned there was a difference between UPDATE STATISTICS commands > AUS > generates vs. what the the seeding script (located at > > http://www-01.ibm.com/support/docview.wss?uid=swg21137764 generates. Other > > than (possibly) the aforementioned resolution/confidence factors, what are > > those differences? And are there plans underway to remedy those > differences > within OAT? > > Thanks in advance. > Clifton > > _________________________________________________________________ > Hotmail: Trusted email with Microsoft's powerful SPAM protection. > http://clk.atdmt.com/GBL/go/177141664/direct/01/ > http://clk.atdmt.com/GBL/go/177141664/direct/01/ > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0015174a047acdd970047791b0e4
John, What percentage of the total row count of a table would you recommend be used if one is generating a variation of the "seeding" script from your webpage (see below)? Are you building a new webpage for 11.50? :) Take care. Clifton > To: ids@iiug.org > From: miller3@us.ibm.com > Subject: Re: OAT and AUS (Auto Update Statistics) [17919] > Date: Wed, 4 Nov 2009 15:17:50 -0500 > > AUS will use confidence, resolution & sample size which was previously > run on the table. So just run the tables once for which you would like to > have high resolutions. As for confidence, I would probably suggest > that you use the new SAMPLING SIZE options as I think it will be > a more meaningful to DBA and application programmers than confidence. > > John F. Miller III > STSM, Support Architect > miller3@us.ibm.com > 503-578-5645 > IBM Informix Dynamic Server (IDS) > > ids-bounces@iiug.org wrote on 11/04/2009 11:51:44 AM: > > > [image removed] > > > > OAT and AUS (Auto Update Statistics) [17912] > > > > Clifton Bean > > > > to: > > > > ids > > > > 11/04/2009 11:52 AM > > > > Sent by: > > > > ids-bounces@iiug.org > > > > Please respond to ids > > > > Is there a way within OAT to state a default RESOLUTION and confidence > factor > > within AUS? > > > > Art, > > > > You mentioned there was a difference between UPDATE STATISTICS commands > AUS > > generates vs. what the the seeding script (located at > > > > http://www-01.ibm.com/support/docview.wss?uid=swg21137764 generates. > Other > > than (possibly) the aforementioned resolution/confidence factors, what > are > > those differences? And are there plans underway to remedy those > differences > > within OAT? > > > > Thanks in advance. > > Clifton > > > > _________________________________________________________________ > > Hotmail: Trusted email with Microsoft's powerful SPAM protection. > > http://clk.atdmt.com/GBL/go/177141664/direct/01/ > > http://clk.atdmt.com/GBL/go/177141664/direct/01/ > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > _________________________________________________________________ Bing brings you maps, menus, and reviews organized in one place. http://www.bing.com/search?q=restaurants&form=MFESRP&publ=WLHMTAG&crea=TEXT_MFES RP_Local_MapsMenu_Resturants_1x1
yes ... I'll have to grab it and take a look ... thanks ... Peter Logan Senior Database Administrator Phone: 616/878-8309 From: "Art Kagel" <art.kagel@gmail.com> To: ids@iiug.org Date: 11/04/2009 03:46 PM Subject: Re: OAT and AUS (Auto Update Statistics) [17923] Sent by: ids-bounces@iiug.org The latest release of dostats can schedule the stats run the same as AUS does to run later using the IDS scheduler. The dostats run does the equivalent of the AUD evaluation phase and schedules the actual run for later as you specify on the commandline. Is that what you are looking for? Art 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. On Wed, Nov 4, 2009 at 3:25 PM, Peter_Logan@spartanstores.com < Peter_Logan@spartanstores.com> wrote: > Has anyone written a script that will build the things for AUS ... if one > doesn't want to use OAT? > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > > From: > "Clifton Bean" <clifton_bean@hotmail.com> > To: > ids@iiug.org > Date: > 11/04/2009 02:52 PM > Subject: > OAT and AUS (Auto Update Statistics) [17912] > Sent by: > ids-bounces@iiug.org > > Is there a way within OAT to state a default RESOLUTION and confidence > factor > within AUS? > > Art, > > You mentioned there was a difference between UPDATE STATISTICS commands > AUS > generates vs. what the the seeding script (located at > > http://www-01.ibm.com/support/docview.wss?uid=swg21137764 generates. Other > > than (possibly) the aforementioned resolution/confidence factors, what are > > those differences? And are there plans underway to remedy those > differences > within OAT? > > Thanks in advance. > Clifton > > _________________________________________________________________ > Hotmail: Trusted email with Microsoft's powerful SPAM protection. > http://clk.atdmt.com/GBL/go/177141664/direct/01/ > http://clk.atdmt.com/GBL/go/177141664/direct/01/ > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0015174a047acdd970047791b0e4 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.