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
Invocation
The statement can be embedded
in an application program or issued through the use of dynamic SQL
statements. It is an executable statement that can be dynamically
prepared.
Authorization
The privileges held by the
authorization ID of the statement must include SQLADM, DBADM, SYSMAINT,
SYSCTRL, or SYSADM authority.
Syntax
>>-FLUSH--+-BUFFERPOOL--+--ALL---------------------------------><
'-BUFFERPOOLS-'
Description
- ALL
- Flushes the dirty pages from all the buffer pools (local and group).
Notes
- Dirty pages processing: Only the dirty pages
that are in the buffer pools when the statement begins processing
are written to disk. Any dirty pages that are added to the buffer
pools before the statement finishes processing are not written to
disk.
- Syntax alternatives: BUFFERPOOL can be specified in place
of BUFFERPOOLS.