Options that affect data sharing performance

GBPCACHE option

Use the GBPCACHE option when you create or alter table spaces or indexes to specify what data, if any, should be cached in the group buffer pool. Valid values for this option are NONE, SYSTEM, CHANGED, and ALL. The default is CHANGED.

MEMBER CLUSTER option

Use the MEMBER CLUSTER option when you create table spaces to specify that Db2 locate data in the table space based on available space rather than clustering the data by the implicit or explicit clustering index.

This option can benefit applications when there are many inserts to the same table from multiple members.

TRACKMOD option

Use the TRACKMOD option when you create or alter table spaces to specify whether you want Db2 to track modified pages in the space map pages of the table space or partition.

TRACKMOD NO can benefit applications when there are frequent updates from multiple members. Be aware that this option can degrade incremental image-copy performance; therefore, specify NO only if you never use incremental copies, or if you use DFSMS concurrent copies and LOGONLY recovery. In these cases, choosing TRACKMOD NO can improve transaction performance.