What I
do know:
- at instance level we've got the util_impact_lim cfg paramater
- the command syntax has extra parameters to overrule this instance paramter (util_impact_priority)
- you can overrule an already running utility with "set util_impact_priority"
What I
do not know:
- is there a hierarchy involved? Suppose I have 3 instances with more databases and i've got the dbm cfg set to 30. Next I start a backup with util_impact_priority = 80. Will the backup get 80% of the 30% assigned to that instance or will be backup get 80% of the total system resources?
- is the throttle looking at the current workload? Suppose I have a dedicated server (no other workload running) and I start a backup with trottle of 50%. Will it run as fast a when I start untrottled (because it does not have to share any other resources) or does is run slower and the system itself is not under full load because of this parameter?
Has the behaviour of all above changed with the versions of db2 (introduced in v8.1.2 and now we are at v9.7.5)? Is this story (
Tackling Slowdowns: Utility Throttling in IBM DB2 UDB V8.1.2 and Beyond — DatabaseJournal.com) still valid? Is the behaviour the same regardless if you use unix, linux or windows?
You need a dedicated server with the right version of db2 to test it all yourself and do not have that at my disposal right now.