Setting DB2 profile variables

Edit online

These two DB2® profile variables described in this topic are explicitly set for this test setup.

  • db2set DB2_USE_ALTERNATE_PAGE_CLEANING=YES

    This variable specifies whether a DB2 database uses the alternate method of page cleaning algorithms or the default method of page cleaning. When this variable is set to ON, the DB2 system writes changed pages to disk, keeping ahead of LSN_GAP and proactively finding victims. Doing this allows the page cleaners to make better use of available disk I/O bandwidth. When this variable is set to ON, the chngpgs_thresh database configuration parameter is no longer relevant because it does not control page cleaner activity.

  • db2set DB2_PINNED_BP=YES

    Setting this variable to YES causes DB2 to request that Linux™ pins DB2 database shared memory. When you configure DB2 to pin database shared memory, make sure that the system is not over committing memory, otherwise Linux have reduced flexibility when it manages memory.