then you may be behind on PTF's and this may be addressed.

We still have this problem ("not so useful index suggestions on system
files") with Index Advisor on test LPAR which is upgraded to 7.1. Upgrade
is done by IBM. We are not part of this activity. Is it possible that bug
in 5.4 still exists after upgrade to 7.1 (latest TR)? This is the reason I
made this post to find out anyone else on 7.1 has the same problem.

If it isn't providing useful information (and I'll agree with Rob,
that's probably a PTF issue), why worry about it?

My concern is about CPU usage by Index advisor. I am not concerned about
disk space used by Index advisor. The update statement on sysixadv (by
Index advisor) shows up once in a while in top 20 SQLs by total CPU usage.
Index advisor might be spending lot more CPU on analysis compared to update
statement on sysixadv. It might save significant amount of CPU by turning
off Index advisor.

Plus, by giving many,many suggestions, Index advisor is no longer useful.
It takes too much time to review thousands of suggestions. Nowadays, we use
Index advisor report only to review temporary indexes(MTI).

This may be a radical solution

Not sure why this is a radical solution. I manage DB2 LUW database for the
same product and there are lot of things that I can leave it to DB2 or
take control when automation does not suit our system. For example, as a
DBA I can leave it to DB2 to collect statistics continuously (just like
iseries) or do it during nightly maintenance window thru shell scripts. By
collecting statistics during off peak hours, I use CPU more effectively.


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.