How to disable auto update statistics

Posted in 2009

CHUAN LU — Tue, 10 Nov 2009 07:20:20 — source: IIUG Forums & Mailing Lists

Hello, I don't want to use this feature before I make sure IDS11.5 is stable, How to disable it? thanks for your help.

↪ replying to CHUAN LU

Clifton Bean — Tue, 10 Nov 2009 14:21:39 — source: IIUG Forums & Mailing Lists

One of the easiest ways is to download the OpenAdmin Tool (OAT) and disable it from within that tool: while you are there, you can look at what AUS is wanting to do and is doing by default every Saturday and Sunday. To download: - Go to openadmintool.org - Click on "Download latest version" on the right - It will take you to "IBM Informix Free Product Download" page, enter IBM login and pwd - On the Offering page, select radio button "IBM Informix Free Product Download" for AIX, HP-UX, Linux, Mac, and Windows. Click on "Continue" - Download whichever product you want. I downloaded the Windows version myself. Take care. Clifton > To: ids@iiug.org > From: luchuan114@sina.com > Subject: How to disable auto update statistics [18023] > Date: Tue, 10 Nov 2009 02:20:21 -0500 > > Hello, > I don't want to use this feature before I make sure IDS11.5 is stable, How to > disable it? thanks for your help. > > > ******************************************************************************* > 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

↪ replying to Clifton Bean

Joseph_Jurcazak@aotx.uscourts.gov — Tue, 10 Nov 2009 14:31:58 — source: IIUG Forums & Mailing Lists

If you don't want to use OAT, run this in dbaccess against the sysadmin database.... update ph_task set tk_enable = "f" where tk_name = "Auto Update Statistics Evaluation"; update ph_task set tk_enable = "f" where tk_name = "Auto Update Statistics Refresh"; Usually the tk_id's are 16 and 17, but I've seen that always isn't the case so using the tk_name's are a little safer. Joe From: "Clifton Bean" <clifton_bean@hotmail.com> To: ids@iiug.org Date: 11/10/2009 08:22 AM Subject: RE: How to disable auto update statistics [18030] Sent by: ids-bounces@iiug.org One of the easiest ways is to download the OpenAdmin Tool (OAT) and disable it from within that tool: while you are there, you can look at what AUS is wanting to do and is doing by default every Saturday and Sunday. To download: - Go to openadmintool.org - Click on "Download latest version" on the right - It will take you to "IBM Informix Free Product Download" page, enter IBM login and pwd - On the Offering page, select radio button "IBM Informix Free Product Download" for AIX, HP-UX, Linux, Mac, and Windows. Click on "Continue" - Download whichever product you want. I downloaded the Windows version myself. Take care. Clifton > To: ids@iiug.org > From: luchuan114@sina.com > Subject: How to disable auto update statistics [18023] > Date: Tue, 10 Nov 2009 02:20:21 -0500 > > Hello, > I don't want to use this feature before I make sure IDS11.5 is stable, How to > disable it? thanks for your help. > > > ******************************************************************************* > 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 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary

UPDATE STATISTICS