Yes,
That would be for static packages only. If you use the DB2PM with some
xtra tracing on you could get the SQL and do it that way.
Its a lot of work.
If this is Zos, why not just run some disk usage reports at the DSN level
and trace that back to the actual index. Or run some reports
with the smf records on the I/O to those datasets. (the indices) You just
need to hope that the disk reports show activity even though
it may be cached.
That way once you have this process in place, you can get a good feel for
whats being used.
"paul"
<db2udbdba-ezmlms
hield-x27504752.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
03/29/2006 05:35
PM Subject
Fwd: RE: UNUSED INDEXES - DB2 UDB
for z/OS
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
---------------------------------------------------------------------
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