Tuning parameters recommended for DB2

About this task

Setting DB2 tuning parameters can improve the performance and scalability of Build Forge systems using an existing DB2 database.
Note: If you change these parameters after Build Forge is installed and running, stop Build Forge before making the changes. Restart Build Forge after you restart DB2.

Procedure

  1. Set the tuning parameters. Run the following DB2 commands:
    db2set DB2_EVALUNCOMMITTED=ON
    db2set DB2_SKIPDELETED=ON
    db2set DB2_SKIPINSERTED=ON

    See DB2 documentation for more information on the effects of these settings.

  2. Restart DB2. This step is required to put the parameters into effect. Be sure there are no sessions running on the database first.
    db2stop force
    db2start

Feedback