I'm at 7.1, but I believe this was available at 6.1 as well. In the
SYSTOOLS library there are a two SQL procedures the deal with the Index
advisor; ACT_ON_INDEX_ADVICE and REMOVE_INDEXES. They aren't quite what
you are asking for, but they should be able to help with writing what
you need.
-Tom Stieger
IT Manager
California Fine Wire
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Cunningham
Sent: Tuesday, March 13, 2012 6:07 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Index Advisor
Does anyone know if there is an API for the Index Advisor? I know it is
all accessible from Navigator but I am thinking about creating a utility
that will read the SYSIXADV table looking for major issues, sending me
an alert about the need for an index, then clear the advisor and start
the process over. Maybe run this monthly. I have been able to read the
SYSIXADV table and find what I consider a major issue and manually
clearing the advisor would be OK, just wanted to try and make it fully
automated.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
