Tuning recommendation to prevent Db2 from frequently going in and out of GBP-dependency

To avoid the need for Db2 to frequently switch in and out of GBP-dependency, tune the subsystem parameters that affect when data sets are switched to a different state.

These parameters can be set through the following fields on installation panel DSNTIPL1:

CHECKPOINT TYPE
RECORDS/CHECKPOINT
MINUTES/CHECKPOINT
RO SWITCH TIME

Note: NOT LOGGED table spaces change their GBP-dependency more often than LOGGED table spaces, because for NOT LOGGED table spaces, RO SWITCH TIME is set to 1. If you run multiple jobs consecutively that modify a NOT LOGGED table space, consider scheduling them to run within an RO SWITCH TIME of one minute, in order to reduce the number of times NOT LOGGED table spaces change their GBP-dependency.