db2 怎样清空缓存

db2 deactivate db dbname  
是可以缓存的收起

db2 deactivate db dbname  
是可以缓存的收起

Option -flushbp is added into db2pdcfg tool to allow usersmanaully flush dirty pages in bufferpool to disk收起

理解楼主的意思，不过印象中没有这样的方法，以前内存资源没这么充足的时候，可以通过查询大表把缓存数据替换掉的方法(缓冲池此时缓存的全是这张大表的数据)，现在服务器内存普遍很大就不太好操作了。收起

这个也是写脏数据的，而不是清空缓冲区的吧收起

http://www-01.ibm.com/support/docview.wss?uid=swg1IZ10053

fp2开始有这个功能收起

我的DB2是9.5的收起

我想问的是把缓冲池中所有的缓存数据全部清空出去的方法
oracle 的ALTER SYSTEM FLUSH BUFFER_CACHE 的作用就是把数据缓冲区清空收起

回复 5# chenxw_mail


    FLUSH BUFFERPOOLS statement

The FLUSH BUFFERPOOLS statement writes the dirty pages from all the local buffer pools for a particular database synchronously to disk.

In DB2® pureScale® environments, the dirty pages in the group buffer pool are also written synchronously to disk.

This statement is not under transaction control.
The FLUSH BUFFERPOOLS statement can be used in the following ways:

    To reduce the recovery window of a database in the event of a failure
    To reduce the size of logs written to a backup image before database operations such as online backups
    To minimize the recovery time of a split-mirror database收起

oracle的ALTER SYSTEM FLUSH BUFFER_CACHE跟db2的flushbp，两者起到的作用是否一样？楼主问的是把缓冲池中所有的缓存数据全部清空出去？db2的flushbp应该只是把缓冲池中的脏页同步刷新到磁盘，不懂oracle，求解释。收起