DB2 10.5 for Linux, UNIX, and Windows

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

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.