Home   |   Register   |   Rules   |   Calendar   |   Get Daily   |     |  
 


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 > Manually flush bufferpools

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-25-10, 14:05
deshaipet deshaipet is offline
Registered User
  
Join Date: Aug 2008
Posts: 76
Manually flush bufferpools
Hi -

Is there any way that I can manually flush the bufferpools ?


Thanks in advance
Panditt
Reply With Quote
  #2 (permalink)  
Old 02-25-10, 14:09
sathyaram_s sathyaram_s is offline
Super Moderator
  
Join Date: Aug 2001
Location: UK
Posts: 4,534
AFAIK, No way to flush the bufferpools ...

the only option is to deactivate and reactivate the db ...

I wish someone will say I am wrong
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
Reply With Quote
  #3 (permalink)  
Old 02-25-10, 14:10
Cougar8000 Cougar8000 is offline
Registered User
  
Join Date: Nov 2005
Location: IL
Posts: 554
you are wrong
__________________
--
IBM Certified DBA on DB2 for Linux, UNIX, and Windows

DB2 v9.1.0.2 os 5.3.0.0
Reply With Quote
  #4 (permalink)  
Old 02-25-10, 14:25
ARWinner ARWinner is offline
Registered User
  
Join Date: Jan 2003
Posts: 3,575
Quote:
Originally Posted by Cougar8000 View Post
you are wrong
Ha. Ha. Ha.
Reply With Quote
  #5 (permalink)  
Old 02-25-10, 14:26
dav1mo dav1mo is offline
Registered User
  
Join Date: Dec 2007
Location: Richmond, VA
Posts: 782
on z/os you can run runstats with update none, not sure if same on LUW
Dave
Reply With Quote
  #6 (permalink)  
Old 02-25-10, 15:36
sathyaram_s sathyaram_s is offline
Super Moderator
  
Join Date: Aug 2001
Location: UK
Posts: 4,534
Quote:
Originally Posted by Cougar8000 View Post
you are wrong
cheers. feeling better now
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
Reply With Quote
  #7 (permalink)  
Old 02-25-10, 18:14
deshaipet deshaipet is offline
Registered User
  
Join Date: Aug 2008
Posts: 76
Finally found it
Finally found the answer in of the IBM forums
Starting in v9.5 FP2, you can use this command to flush BPs:
db2pdcfg -db <dbname> -flushbp

Earlier versions, you need to deactivate and activate the database to flush BPs.

Regards,
Wiliam
Thanks
Panditt
Reply With Quote
  #8 (permalink)  
Old 02-25-10, 22:43
sathyaram_s sathyaram_s is offline
Super Moderator
  
Join Date: Aug 2001
Location: UK
Posts: 4,534
Panditt, thanks for taking time to provide this information here ..
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
Reply With Quote
  #9 (permalink)  
Old 02-26-10, 15:27
ARWinner ARWinner is offline
Registered User
  
Join Date: Jan 2003
Posts: 3,575
The -flushbp does not flush the entire bufferpool - as opposed to deactivating the DB. I looked up the APAR for the fix and it only flushes the dirty pages to disk.

IBM IZ10053: ADDING DB2PDCFG -FLUSHBP - United States

Andy
Reply With Quote
  #10 (permalink)  
Old 02-27-10, 02:27
sathyaram_s sathyaram_s is offline
Super Moderator
  
Join Date: Aug 2001
Location: UK
Posts: 4,534
Yes, Andy ... i noticed it ...

What it means is db2 writes dirty pages to the disk, but does not remove them from the bufferpool ...

If the OP is after removing the pages from the bufferpool, this command will not help
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

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


 
 
 
Home  |   Register  |   Get New  |   FAQ's  |   Sitemap

Powered by vBulletin
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.