Automatic recovery requirements for group buffer pools

Automatic recovery is faster than manual recovery because Db2 can optimize internal processing of the recovery.

For automatic recovery to be initiated for a group buffer pool, all of the following conditions must be true:
  • AUTOREC (YES) is specified for the group buffer pool.
  • At least one member is actively connected at the time that the group buffer pool failed. This member must have successfully completed damage assessment.
Db2 never initiates automatic recovery during restart.

For a duplexed group buffer pool, Db2 can use automatic recovery if both instances of the group buffer pool are damaged. Automatic recovery is not needed for group buffer pools that are defined as GBPCACHE (NO).

You can enable automatic recovery with the AUTOREC option of the ALTER GROUPBUFFERPOOL command.