RE: DB2 Indices

["Weatherly, Howard" <hweatherly@xxxxxxxxxxxx>]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
Well just in general, say some user complains about slowness on a job that
has been running for a while, given the current mix of other things and
ruleing them out as the problem, I am left with wondering if the environment
has changed such that any or in fact the absense of an index on that job may
be the problem. So without re-compiling and running in debug mode to see
what is happening, I was curious if there was some simple way to determine
what indices are or are not being used. I sure wish some more of the
mainframe tools would migrate down to the midrange in some form or another!

-----Original Message-----
From: thomas@inorbit.com [mailto:thomas@inorbit.com]
Sent: Friday, October 19, 2001 12:11 AM
To: midrange-l@midrange.com
Subject: Re: DB2 Indices


On Mon, 15 October 2001, "Weatherly, Howard" wrote:

> What is the simplest way to determine if an Index is being used?

Being used anywhere ever? being used in a particular job? or being used in a
particular function?

Tom Liotta

--
Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone  253-872-7788
Fax  253-872-7904
http://www.400Security.com


___________________________________________________
The ALL NEW CS2000 from CompuServe
 Better!  Faster! More Powerful!
 250 FREE hours! Sign-on Now!
 http://www.compuserve.com/trycsrv/cs2000/webmail/




_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.