Results 1 to 10 of 10
  1. #1
    Join Date
    Aug 2008
    Posts
    76

    Unanswered: Manually flush bufferpools

    Hi -

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


    Thanks in advance
    Panditt

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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.

  3. #3
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    you are wrong
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Quote Originally Posted by Cougar8000 View Post
    you are wrong
    Ha. Ha. Ha.

  5. #5
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    on z/os you can run runstats with update none, not sure if same on LUW
    Dave

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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.

  7. #7
    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

  8. #8
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Panditt, thanks for taking time to provide this information here ..
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  9. #9
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  10. #10
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •