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 > pool_drty_pg_thrsh_clns and pool_drty_pg_steal_clns monitor elements

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-23-08, 14:05
azs0309 azs0309 is offline
Registered User
 
Join Date: Jan 2008
Posts: 88
pool_drty_pg_thrsh_clns and pool_drty_pg_steal_clns monitor elements

I was going through two monitor elements of DB2 pool_drty_pg_thrsh_clns(dirty pages thresold cleaner) and pool_drty_pg_steal_clns(Dirty pages steal cleaner). what i dont understand is when u have thresold cleaner ,how DB2 reaches to the point where it has to steal some victim pages. for eg: if I have 1 GB of bufferpool and changed pages thresold DB parameter is set to 60% then it should always trigger when the bufferpool has 600MB of dirty pages, it should not allow to the point where the whole bufferpool is of dirty pages and it has to stea some pages.
Am I missing something here? please let me know ur views.
Reply With Quote
  #2 (permalink)  
Old 01-23-08, 15:24
ARWinner ARWinner is offline
Registered User
 
Join Date: Jan 2003
Posts: 3,575
You have a misunderstanding of what the monitor element is. Here is the definition:

The number of times a page cleaner was invoked because a synchronous write was needed during the victim buffer replacement for the database.

Basically this means that a page cleaner, which is asynchronous, that was busy doing its thing was needed because of a synchronous write.

Andy
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