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

Deactivate database and activate it ...

Cheers
Sathyaram

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

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

Hi,

Please also check the buffer pool questions.

Hope this helps,
Grofaty

Which version of DB2 R U using, let me know


Lekharaju Ennam