Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2009
    Posts
    66

    Unanswered: clean buffer pool

    Can we clean the bufferpools on DB2 9.5.5 for Linux?

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    The only way I know to "clean" the bufferpools is to "restart" the database. This can be accomplished by having all applications disconnect, and deactivating the database if it was manually activated.

    Andy

  3. #3
    Join Date
    Sep 2009
    Posts
    66
    Is there a way to clean the buffer pool of dirtry pages without restarting the database?

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Not that I know of.

    Andy

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by L_DBA_L View Post
    to clean the buffer pool of dirtry pages without restarting the database?
    Check flushbp option mentioned here:
    What is new in DB2 Express-C: Clearing DB2 bufferpools | FreeDB2.com

    This option will write dirty pages to disk but leave them in the bufferpool as clean.

  6. #6
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by db2girl View Post
    Check flushbp option mentioned here:
    What is new in DB2 Express-C: Clearing DB2 bufferpools | FreeDB2.com

    This option will write dirty pages to disk but leave them in the bufferpool as clean.
    That command does flush dirty (updated) pages from the buffer pool to disk, but does not actually clear the bufferpools. I beleive that archive log command also flushes dirty pages to disk.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  7. #7
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    The pages will remain in the bufferpools as clean

Posting Permissions

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