Setting environment variables and registry variables for optimal performance

Registry variables store configuration settings that can be applied at a global or instance level. An environment variable can set multiple registry variables based on pre-defined settings. When you set the DB2_WORKLOAD environment variable to MAXIMO, you efficiently change several registry variables to settings that are optimized for Maximo® Asset Management.

About this task

The MAXIMO value for the DB2_WORKLOAD environment variable was first introduced in DB2® version 9.5, fix pack 5. If you are using DB2 version 9.5 do not have fix pack 5, you cannot use the MAXIMO value for the DB2_WORKLOAD environment variable.

Procedure

  1. In the command prompt on the server on which DB2 is installed, run the following command:
    db2set DB2_WORKLOAD=MAXIMO
    The following registry values are automatically set:
    Registry variable Value
    DB2_SKIPINSERTED ON
    DB2_INLIST_TO_NLJN YES
    DB2_MINIMIZE_LISTPREFETCH YES
    DB2_EVALUNCOMMITTED YES
    DB2_SKIPDELETED ON
  2. If you are using DB2 version 9.7, or later, run the following command:
    db2set DB2_USE_ALTERNATE_PAGE_CLEANING=ON
    The DB2_USE_ALTERNATE_PAGE_CLEANING registry variable speeds up the process of creating or altering large table spaces.
  3. If you are using the Windows or UNIX operating system, run the following command:
    db2set DB2_FMP_COMM_HEAPSZ=65536
    The DB2_FMP_COMM_HEAPSZ registry variable sets the size of the heap that is used for fenced routine invocations.
  4. To apply the settings that you changed, stop and restart DB2.


Feedback