List of Contributions

PAUL BIRD

Contact Details

My Content

1 to 3 of 3 total
Posted By PAUL BIRD Mar 3, 2020 9:58 AM
Found In Library: Db2 (On Premise and Cloud)
*** With closure of IBM Developerworks, the GWLM community site is no longer available. Making last GWLM update available here for download until alternative arrangements are created. The IBM Graphical Workload Management Tool, informally referred to as the GWLM tool, is provided as-is for use ...
Posted By PAUL BIRD Nov 23, 2018 10:43 AM
Found In Egroup: Db2 On Premise and Cloud
\ view thread
Hi, If you want to see the current statements that are in lockwait, then the MON_LOCKWAITS view or theMONREPORT.LOCKWAIT stored procedure (https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.apdv.sqlpl.doc/doc/r0056374.html) will show you all the information you need. If you ...
Posted By PAUL BIRD Nov 21, 2018 12:52 AM
Found In Egroup: Db2 On Premise and Cloud
\ view thread
There are a number of ways to get information about lock holders and locks available in Db2. There are the lower level table functions: MON_GET_LOCKS MON_GET_APPL_LOCKWAIT MON_FORMAT_LOCK_NAME And there are the higher level MON_LOCKWAITS administrative views and LOCKING event monitor. You ...