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
--- This message (including any attachments) is intended only for the use of the individual or entity to which it is addressed and may contain information that is non-public, proprietary, privileged, confidential, and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any use, dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us and destroy this message immediately. ---
midrange.com
