I know that you can explicitly reset the data (either a single advised index or all for a particular library) via iSeries Navigator. I don't know if there's any system task that will automatically clean them up.
Matt
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Bryce Martin
Sent: Monday, August 31, 2009 10:46 AM
To: RPG programming on the IBM i / System i
Subject: Re: AW: system performance
BTW beginning with release V5R4 all advised indexes are stored in a
physical
file (SYSIXADV) located within the library QSYS2. In this table not only
the
advised indexes are stored, but also how often they were advised and when
the last advice took place. The easiest way to analyze this proposed
indexes
is to use the iSeries navigator, but it is also possible to access this
table with SQL or Query/400. <<<<
Birgitta,
Does this file ever get reset? If you have a couple of heavy offenders in
the file and you try to fix it by creating the advised indices how then
would you know if it is working. I guess the last date it was requested
would not change anymore, but it would still show a lot of requests. There
are some on there that have a lot of requests and the date is a month old
or something along thos lines. So maybe this is a month end program
causing it? Or a not often used program? I could use sql to reset the
number I guess, but is there anything that it would screw up if that was
the case?
Thanks
Bryce Martin
Programmer/Analyst I
570-546-4777
midrange.com
