Technical Blog Post
Abstract
How to stop or force AutoRunstat off while its running?
Body
Unfortunately we will not be able to stop a runstats while it is running.
This would lead to inconsistent data in the catalog.
A "db2stop force" will work ( likely ) at the end of the runstats. So
useless. As it didn't worked for you it must be in initial or middle process.
What might work, is to revise the priority of the process. That can be
done with the parameter util_impact_lim and the command "set
util_impact_priority", Please review for
In case AutoRunstat is running at pick hours and affecting performance of system.
For the future, either disable the auto runstats, or give a rule to have
only sampled statistics ( this might have a negative impact on computing
access plans ). In my opinion, better is to schedule runstats during
"maintenance periods" were you know that there will be few or no other
activities
UID
ibm13285855