13同行回答
回复 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收起
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收起
浏览3995