The dropping of a large index can consume a significant amount of time. What are the background activities involved in the drop that consume time?
Pinned topic Drop Index background activities
mor 110000Q8NJ577 Posts
Re: Drop Index background activities2014-08-19T09:58:14ZThis is the accepted answer. This is the accepted answer.
When asking for help, always give your DB2-server version+fixpack and the operating-system-name and version, because the answers can depend on these facts...
Drop index: tablespace updates (pages freed etc), catalog updates, packages invalidated, cached dynamic-SQL invalidated, Xquery-statements invalidated etc.
With catalog updates, there can be lock waits...
andrewmcl 2700077MEM119 Posts
Re: Drop Index background activities2014-08-19T23:26:24ZThis is the accepted answer. This is the accepted answer.