Please excuse my ignorance here, but wouldn;t this solution only work for Static SQL?

PL

> To: "LazyDBA Discussion" <[Email address protected]
> From: "mitesh_nagar" <db2udbdba-ezmlmshield-x56291115.[Email address protected]
> Date: Thu, 30 Mar 2006 08:30:29 +1200
> Subject: RE: UNUSED INDEXES - DB2 UDB for z/OS
>
> 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
>
>
> ---------------------------------------------------------------------
> 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