IBM Support

How to stop or force AutoRunstat off while its running?

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

https://www.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0011773.html

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

[{"Business Unit":{"code":"BU029","label":"Data and AI"}, "Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm13285855