If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > who does fully understand "throtteling" in db2 luw?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-27-12, 05:33
dr_te_z dr_te_z is offline
Registered User
 
Join Date: Jan 2009
Location: Zoetermeer, Holland
Posts: 555
who does fully understand "throtteling" in db2 luw?

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.
Reply With Quote
  #2 (permalink)  
Old 01-27-12, 07:56
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
Quote:
Originally Posted by dr_te_z View Post
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?
As far as I know, it's neither. In your example, if the backup is the only throttled utility, it will get all of the 30% of the server resources as defined by UTIL_IMPACT_LIM. If, on the other hand, you have a concurrent REORG with UTIL_IMPACT_PRIORITY of 40, the backup will get 30*80/(80+40) = 20% of the server resources, while REORG will get the remaining 10%.
Reply With Quote
  #3 (permalink)  
Old 01-27-12, 08:22
dr_te_z dr_te_z is offline
Registered User
 
Join Date: Jan 2009
Location: Zoetermeer, Holland
Posts: 555
Please evaluate my assumption:
- util_impact_lim dbm cfg is set to a value
- I have an idle system and I must perform an online bakcup as fast as possible
- I must specify UTIL_IMPACT_LIM = 100 in my backup command to overrule the dbm cfg
- In this situation an online backup executes unthrottled and is as fast as an offline backup (all our restore scripts are based on an online image + rollforward) and all server-resources are used

Check?
Reply With Quote
  #4 (permalink)  
Old 01-27-12, 08:47
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
Not really. Why don't you read the manual for a change?

To run unthrottled, either specify UTIL_IMPACT_PRIORITY=0 (which means unthrottled) or don't specify it at all (which means the same thing).
Reply With Quote
  #5 (permalink)  
Old 01-27-12, 09:47
dr_te_z dr_te_z is offline
Registered User
 
Join Date: Jan 2009
Location: Zoetermeer, Holland
Posts: 555
Quote:
Originally Posted by n_i View Post
Why don't you read the manual for a change?
I am, believe me. It is not always too clear (or have it your way: I am too stupid to understand)
Quote:
Originally Posted by n_i View Post
or don't specify it at all (which means the same thing).
Then what does the DBM CFG do???
Reply With Quote
  #6 (permalink)  
Old 01-27-12, 11:14
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
Quote:
Originally Posted by dr_te_z View Post
(or have it your way: I am too stupid to understand)
I didn't say that, did I?

Quote:
Originally Posted by dr_te_z View Post
Then what does the DBM CFG do???
UTIL_IMPACT_LIM sets the limit of server resources for all _throttled_ utilities. You make utilities _throttled_ by specifying UTIL_IMPACT_PRIORITY. If you don't specify UTIL_IMPACT_PRIORITY, the utility runs unthrottled and as such it is not subject to the instance-level limit.

Seriously, it's just one page in the manual. SET UTIL_IMPACT_PRIORITY - IBM DB2 9.7 for Linux, UNIX, and Windows
Reply With Quote
  #7 (permalink)  
Old 01-30-12, 02:38
dr_te_z dr_te_z is offline
Registered User
 
Join Date: Jan 2009
Location: Zoetermeer, Holland
Posts: 555
Quote:
Originally Posted by n_i View Post
I didn't say that, did I?
To be honest: no you did not. You gave me the "RTFM" and that made me a bit grumpy (http://4.bp.*************/_sRPw9B-CaG...nd+Waldorf.jpg).

I re-read you link and I looked up the exact meaning of the word "irrespective" and now I understand that there is an "and" relationship between the DBM CFG setting and the "util_impact_prio" parameter in the commands. I was under the impression that the DBM CFG set a default for all ultilities and the "util_impact_prio" was used to overrule that.
Thanks for your help of making that clear.

Next weekend will be our conversion weekend from 9.5 to 9.7 and we are not allowed to use too much "downtime" so the restore & backup's MUST go at full speed.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On