Question & Answer
Question
How to modify DB2 registry variables to improve performance and decrease number of locks owned by MAXIMO application.
Cause
MAXIMO application running slow and shows a large number of locks.
Answer
The following DB variables should be set to "ON"
DB2_EVALUNCOMMITTED
DB2_SKIPDELETED
DB2_SKIPINSERTED
Please run commands as follows, the sysadm authorisation level is required:
1) db2set -all
The output of this command would provide the names and values of registry variables that have been set.
If any of the above variables have not been set please run repeating for every variable:
db2set DB2_SKIPDELETED=ON
[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"System Related","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"6.2;6.2.1;6.2.2;6.2.3;6.2.4;6.2.5;6.2.6;6.2.7;6.2.8;7.1;7.1.1;7.5;7.6","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21451593