Re: Index Advisor

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hey Gord

How about entering and RFE for IBM to provide tooling to manage older 
recommended indexes? Or is there already something like that?

Vern

On 8/7/2018 12:57 PM, Gord Hutchinson wrote:
> I would like to do some cleanup of the older recommended indexes.  As well,
> I have recommendations for indexes in libraries that no longer exist.
> Working with the schemas is ACS is cumbersome since it doesn't allow
> selecting or positioning when in the index advisor.  Each time a
> recommendation is deleted the display is refreshed thus losing the
> positioning.  I find the web navigator slow as well.
>
>
>
> Gord
>
>
>
>
> On Tue, Aug 7, 2018 at 10:45 AM, Rob Berendt <rob@xxxxxxxxx> wrote:
>
> > "Hard" restrictions can normally be determined by DSPFD and looking at
> > Allow read operation  . . . . . . . . . . . :            Yes
> > Allow write operation . . . . . . . . . . . :            Yes
> > Allow update operation  . . . . . . . . . . : ALWUPD     *YES
> > Allow delete operation  . . . . . . . . . . : ALWDLT     *YES
> >
> > This file is flagged as all yes (as shown above).  I've seen some which
> > were not, such as SYSTABLES, and temporal table log files.
> >
> > This doesn't address your concern about "admonitions".
> >
> >
> >
> > Rob Berendt
> > --
> > IBM Certified System Administrator - IBM i 6.1
> > Group Dekko
> > Dept 1600
> > Mail to:  2505 Dekko Drive
> >            Garrett, IN 46738
> > Ship to:  Dock 108
> >            6928N 400E
> >            Kendallville, IN 46755
> > http://www.dekko.com
> >
> >
> >
> >
> >
> > From:   "Gord Hutchinson" <gordm1@xxxxxxxxxxxxxxx>
> > To:     "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
> > Date:   08/07/2018 10:32 AM
> > Subject:        Index Advisor
> > Sent by:        "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
> >
> >
> >
> > Are there any restrictions, prohibitions, admonitions on updating
> > QSYS2.SYSIXADV in SQL or a program?
> >
> >
> >
> >
> > Gord
> >
> >
> >
> > --
> > Gord Hutchinson
> > TFI International
> > --
> > 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: https://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/midrange-l.
> >
> > Please contact support@xxxxxxxxxxxx for any subscription related
> > questions.
> >
> > Help support midrange.com by shopping at amazon.com with our affiliate
> > link: http://amzn.to/2dEadiD
> >
> >
> > --
> > 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: https://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/midrange-l.
> >
> > Please contact support@xxxxxxxxxxxx for any subscription related
> > questions.
> >
> > Help support midrange.com by shopping at amazon.com with our affiliate
> > link: http://amzn.to/2dEadiD