Indexspacestats Good News

Jorg Lueke

Indexspacestats Good News
While DB2 9 has been a bit of a challenge we are now able to start applying
some of the nice features. Using the LASTUSED column of
SYSINDEXSPACESTATS we have found a lot of indexes that haven't been
used in at least a year

These are our index stats

265GB unused versus 790GB used in our data sharing environment (mostly
from the OLAP things)

83GB unused versus 339GB used in out stand alone DB2

29GB unused versus 152GB used in the full size SAP environments.

I didn't check test since we need to keep environments consistent. I doubt
we can go through SAP and do much either, but the other 348GB we should
be able to get back.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L