Infrastructure (Server, Network, Database)

Showing results for 
Search instead for 
Did you mean: 

Disable MON_LOCKWAITS on DB2 monitor




We have DB2 agent set-up in our env. The agent runs and collects data, however the Application team has reported the DB2 user being used to collect perf data runs a query to collect info on lockwait calls that takes a longer time (SYSIBMADM.MON_LOCKWAITS calls)


It was suggested to disable those calls in DB2 using this JVM arg, while restarting the DB2 agent


-Ddbagent.blockingtree.enabled.dbs='ORACLE;MSSQL;SYBASE'         ---> excludes DB2


Has anyone tested this and works as expected, to disbale SELECT privilege on the MON_LOCKWAITS administrative view ? Please advise




Disable MON_LOCKWAITS on DB2 monitor