Manual bufferpool flush

[deshaipet]

Hi -

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


Thanks in advance
Panditt

[deshaipet]

Finally found the answer in one 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