Look at query patroller



(its an IBM tool)




"Lopez Garcia
Ramiro "
<db2udbdba-ezmlms To
hield-x77806810.x "LazyDBA Discussion"
[Email Address Removed] <[Email address protected]
a.com> cc

03/27/2006 06:04 Subject
PM UNUSED INDEXES - DB2 UDB for z/OS










Hi all ....

Is there any tool or process (query) to help me know what indexes are not
used in order to delete them?

Furthermore, I want to know what tables, views, columns are not used to do
the same (delete), have you
any idea ?

I have a warehouse with hundreds of objects and a lot of space that I want
to improve.


DB2 V7
z/OS v 1.4
90% of my SQL is DYNAMIC

Thanks for your help!

Ram




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DB2 & UDB email list listserv db2-l LazyDBA home page