Changing the GBPCACHE attribute

The GBPCACHE option determines whether the group buffer pool is to be used for both caching and cross-invalidation.

About this task

The GBPCACHE option can be set to YES or NO. A value of YES indicates that the group buffer pool is to be used for both caching and cross-invalidation. A value of NO indicates that the group buffer pool is to be used only for cross-invalidation.

Procedure

To change the GBPCACHE attribute:

  1. Submit the ALTER GROUPBUFFERPOOL command with the GBPCACHE option.
  2. Rebuild the group buffer pool by using the SETXCF START,REBUILD,STRNAME=strname command to make the change take effect.

    A group buffer pool with a GBPCACHE(NO) attribute can be duplexed. However, if the group buffer pool attribute is set to GBPCACHE(YES) and the NO attribute is pending, DB2® ignores the pending GBPCACHE(NO) attribute if you start a duplexing rebuild.