Have you tried selecting from the catalog on table SYSIBM.SYSPACKDEP, and
joining that to the SYSIBM.SYSINDEX table, to see what is in
SYSIBM.SYSINDEX but not in SYSIBM.SYSPACKDEP? This will tell you which
indexes are not used by any programs.

Other than this you will need a monitoring tool, to get the info. also
best to ensure your stats are up to date first, as this could change the
access path, and you might get an index to be used if the stats change.


Cheers.






"Lopez Garcia Ramiro "
<db2udbdba-ezmlmshield-x92448770.[Email address protected]
30/03/2006 04:41


To: "LazyDBA Discussion" <[Email address protected]
cc:
Subject: RE: UNUSED INDEXES - DB2 UDB for z/OS


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



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





The contents of this e-mail are confidential. If you have received this communication by mistake, please advise the sender immediately and delete the message and any attachments. Nothing in this email designates an information system for the purposes of Section 11(a) of the New Zealand Electronic Transactions Act 2002.
Westpac Banking Corporation, ABN 33 007 457 141, is incorporated in Australia

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