Environment : DB2 9.7 fix pack 6, OS : red hat, Single partition,Datawarehouse
In my environment, many utilities like load,runstats,backups will run often.
BUt for huge tables runstats is running for very long time and due to that remaining jobs are getting slow.
I just want to know which priorty is best ? and what is unthrottled ?
ID = 9739
Type = RUNSTATS
Database Name = EDW
Partition Number = 0
Description = EDW.STAY_HEADER
Start Time = 06/18/2014 16:00:07.525746
State = Executing
Invocation Type = User
Priority = Unthrottled
db2 get dbm cfg | grep -i util*
Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10
You did not give the db size in terabytes/gigabytes, but if this is a warehouse with runstats taking too long, you may get more mileage from introducing sampling into your runstats profiles (or reducing sampling size if you already use sampling). Also ensure your util_heap_sz is as high as you can afford.
In other words, throttling may give you less benefits than reducing the amount of work (via sampling).