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
- 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 |
- 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.
- 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.
- To apply the settings that you changed, stop and restart DB2.