Thanks Daniel, I have been reading something about Query Patroller,
but right now Query Patroller is not installed in the mainframe, maybe
in the future.

So, Is there any other way to know this UNUSED INDEXES ?


-----Mensaje original-----
De: DANIEL CALLAHAN


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


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