Search code examples
db2ibm-clouddb2-luw

How can I drop a locked table in DB2 on Cloud?


I'm having trouble with a locked object (table) in my DB2onCloud, I can't drop the table I also did the 'Force Application' but it didn't worked.enter image description here

enter image description here


Solution

  • I figured it out, how to kill these objects. It seems they are EVENTS Monitoring. So I just executed this command 'SET EVENT MONITOR capturestats STATE 0', and it works. Thanks for all the help.