Infrastructure (Server, Network, Database)

cancel
Showing results for 
Search instead for 
Did you mean: 

Disable MON_LOCKWAITS on DB2 monitor

Disable MON_LOCKWAITS on DB2 monitor

Hello!

 

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

 

-TIA

 

Disable MON_LOCKWAITS on DB2 monitor