Re: AW: system performance

Luis,
I'm asking about clearing or resetting values in SYSIXADV. These are not
reset on IPL. I figured it would stop counting if I created the index.
Which it should since it would find the index and not have a reason to
count anymore.


Thanks
Bryce Martin
Programmer/Analyst I
570-546-4777



Luis Rodriguez <luisro58@xxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
08/31/2009 07:15 AM
Please respond to
RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>


To
"RPG programming on the IBM i / System i" <rpg400-l@xxxxxxxxxxxx>
cc

Subject
Re: AW: system performance






The MTIs (Maintained Temporary Indexes) are cleared during an IPL or,
as Matt wrote, using iSeries Nav. The SYSIXADV would show, IIRC, the
last date such index was advised, so maybe you could use that as a
reference point. Also, there is a counter that stops increasing when
you create a (permanent) index with the characteristics suggested by
the index advisor.

Hope this helps,


Luis Rodriguez
IBM Certified Systems Expert â eServer i5 iSeries



On Mon, Aug 31, 2009 at 10:30 AM, Haas, Matt (CL Tech
Sv)<matt.haas@xxxxxxxxxxx> wrote:

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
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing

list

To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.