Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2003
    Posts
    39

    Unanswered: Flushing bufferpool

    Hello,

    I need to monitor the excution time of the querry,for that I want there should be no pages in the bufferpool ,and it should begin with fetching from the disk into the buffer ,can anyone please tell me how to flush the pages from BP..Any help wld be appreciated


    with regards
    ashaq

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Flushing bufferpool

    Deactivate database and activate it ...

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Dec 2003
    Posts
    39

    Re: Flushing bufferpool

    hello satyaraam,

    Thx for the suggestion,Is there no commond as we have in Oracle to flush the BF..In my case deactvating is not possible

  4. #4
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    To Add.

    Hi Ashaq,

    As Sathyaram mentioned that is the only option available. However what I would also suggest is a restart of your Operating system as well in case you are looking for perfect figures as I am not sure whether the Deactivate database command would flush the operating system cache as well. On NT there is an os cache parameter DB2NTNOCACHE which is for the OS Cache.

    There is no command to start/stop bufferpools to the best of my knowledge as well.

    Cheers

    Nitin
    HTH

    Nitin

    Ask the experienced rather than the learned

  5. #5
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,

    Please also check the buffer pool questions.

    Hope this helps,
    Grofaty

  6. #6
    Join Date
    Jan 2004
    Location
    Tallahassee, FL, USA
    Posts
    96

    Re: Flushing bufferpool

    Originally posted by ashaq
    Hello,

    I need to monitor the excution time of the querry,for that I want there should be no pages in the bufferpool ,and it should begin with fetching from the disk into the buffer ,can anyone please tell me how to flush the pages from BP..Any help wld be appreciated


    with regards
    ashaq
    Which version of DB2 R U using, let me know


    Lekharaju Ennam

Posting Permissions

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