Re: Index Advisor

[Gord Hutchinson <gordm1@xxxxxxxxxxxxxxx>]

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