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?
mor 110000Q8NJ548 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 2700077MEM110 Posts
Re: Drop Index background activities2014-08-19T23:26:24ZThis is the accepted answer. This is the accepted answer.
- mor 110000Q8NJ
Yes, my mistake. I should have added DB2 10.5 FP1 On SUSE 11 PL 3 (Intel 64 bit). When it frees tablespace pages I presume it has to modify each page header. Is that correct? And I presume it also modifies the compression dictionary