How to singly stop Auto update statistics

Question & Answer

Question

Now IDS11.5 had built "auto update statistics " default,but it is a low level statistics,and maybe encounter some resource problem,so we had to stop it sometime.

Cause

There are many schedulers in sysadmin database including "Auto update statistics".They will all be closed it if we execute function "admin(scheduler shutdown)" ,which could affect IDS11.5 engine run stably.

Answer

We can analyse some function table in sysadmin and singly stop the AUS.The ph_task table collect all "scheduler" in sysadmin,so we can delete the record for stopping AUS.

"unload to /tmp/task.bak select * from ph_task where tk_id=17"

"delete from ph_task where tk_id = 17"

 

 

출처 : https://www.ibm.com/support/pages/how-singly-stop-auto-update-statistics?view=full