AUS - Update Statistics
Solaris 10 Sparc IDS 11.50.FC8 I have never used AUS before, and I thought I would like to set it up for the first time. I was wondering if someone can send me something, commands, whatever, to set it up and have it start running. I would like to run it on the following schedule. Will it decide which tables statistics need to be updated most each night, or will it end up updating statistics for the same tables each night? Run nightly from 2200 to 0300 Monday - Saturday if it needs to. Run as much as it needs to on Sunday. Any help will be appreciated. Larry
This is probably as good a place to start as any: https://informixdba.wordpress.com/2015/04/30/experience-with-auto-update-statist ics-aus/ To meet the Monday -Saturday schedule update the tk_start_time, tk_stop_time, and tk_<day_of_week> columns in sysadmin:ph_task for 'Auto Update Statistics Refresh'. Insert a second 'Auto Update Statistics Refresh' task to handle a different schedule on Sundays (additional AUS refresh tasks are mentioned in the link above). HTH Stuart --- Ardenta Limited is ISO/IEC 20000-1 certified. We are proud to be named IT Supplier Of The Year 2014 and 2013 at eGR B2B Awards. Ardenta Limited is a company registered in England and Wales. Registered number: 4181041. Registered office: Saxon House, Downside, Sunbury on Thames, Middlesex, TW16 6RT. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of LARRY SORENSEN Sent: 11 May 2016 03:02 To: ids@iiug.org Subject: AUS - Update Statistics [37095] Solaris 10 Sparc IDS 11.50.FC8 I have never used AUS before, and I thought I would like to set it up for the first time. I was wondering if someone can send me something, commands, whatever, to set it up and have it start running. I would like to run it on the following schedule. Will it decide which tables statistics need to be updated most each night, or will it end up updating statistics for the same tables each night? Run nightly from 2200 to 0300 Monday - Saturday if it needs to. Run as much as it needs to on Sunday. Any help will be appreciated. Larry ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Thank you for your help. That is what I was thinking. I will take a look at the link. Larry ________________________________________ From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Stuart Brooks <stuart.brooks@ardenta.com> Sent: Thursday, May 12, 2016 7:46 AM To: ids@iiug.org Subject: RE: AUS - Update Statistics [37101] This is probably as good a place to start as any: https://informixdba.wordpress.com/2015/04/30/experience-with-auto-update-statist ics-aus/ To meet the Monday -Saturday schedule update the tk_start_time, tk_stop_time, and tk_<day_of_week> columns in sysadmin:ph_task for 'Auto Update Statistics Refresh'. Insert a second 'Auto Update Statistics Refresh' task to handle a different schedule on Sundays (additional AUS refresh tasks are mentioned in the link above). HTH Stuart --- Ardenta Limited is ISO/IEC 20000-1 certified. We are proud to be named IT Supplier Of The Year 2014 and 2013 at eGR B2B Awards. Ardenta Limited is a company registered in England and Wales. Registered number: 4181041. Registered office: Saxon House, Downside, Sunbury on Thames, Middlesex, TW16 6RT. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of LARRY SORENSEN Sent: 11 May 2016 03:02 To: ids@iiug.org Subject: AUS - Update Statistics [37095] Solaris 10 Sparc IDS 11.50.FC8 I have never used AUS before, and I thought I would like to set it up for the first time. I was wondering if someone can send me something, commands, whatever, to set it up and have it start running. I would like to run it on the following schedule. Will it decide which tables statistics need to be updated most each night, or will it end up updating statistics for the same tables each night? Run nightly from 2200 to 0300 Monday - Saturday if it needs to. Run as much as it needs to on Sunday. Any help will be appreciated. Larry ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.