Re: iNAV Index Advisor Advising Duplicate Indexes

[Luis Rodriguez <luisro58@xxxxxxxxx>]

Brian,

I seem to remember a similar discussion some time ago on this forum...
One of the possibilities is that the optimizer is timing out before it
finds the desired index.


Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries



On Fri, Jan 15, 2010 at 4:04 PM, Brian Piotrowski
<bpiotrowski@xxxxxxxxxxxxxxx> wrote:
> Hi All,
>
> Has anyone else had an issue with the iNAV index advisor advising on an index that has already been created?  I'm looking at what the advisor is telling us to create for indexes, but when I look under the indexes that have already been created, this index already exists.
>
> Out of curiosity, I created it based on the recommendations by the IA.  However, when I run the IA again, the same index shows up looking to be created.
>
> Any ideas why?
>
> Thanks!
>
> /b;
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> Brian Piotrowski
> Assistant Mgr. - I.T.
> Simcoe Parts Service, Inc.
> Ph: 705-435-7814 x343
> Fx: 705-435-6746
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> http://www.simcoeparts.com
>
> --
> 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: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.