Re: Index Advisor

[DrFranken <midrange@xxxxxxxxxxxx>]

It totally (as it turns out) depend on WHERE in the tree you are when 
you select the Index Advisor. The one I was using was the system only 
with no ability to select libraries. Once I drilled into the correct 
location shazaam, there they are.

        - Larry "DrFranken" Bolhuis

www.Frankeni.com
www.iDevCloud.com - Personal Development IBM i timeshare service.
www.iInTheCloud.com - Commercial IBM i Cloud Hosting.

On 10/27/2016 9:27 AM, Jim Oberholtzer wrote:
> You have to get all of the libraries into the list the advisor shows, right
> now the only one in there is QUSRSYS.  I really hate that interface because
> it is not intuitive at all.  Once you figure that out you'll get your
> advised indexes.
>
> --
> Jim Oberholtzer
> Agile Technology Architects
>
>
> -----Original Message-----
> From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
> DrFranken
> Sent: Thursday, October 27, 2016 8:18 AM
> To: Midrange Systems Technical Discussion
> Subject: Index Advisor
>
> Bizzarre that in the Index Advisor for a system with thousands of tables in
> production data library and heavy SQL use that there are exactly zero
> entries in the Index Advisor for any tables except for QUSRSYS.
>
> While I have a problem open with IBM on this they have not yet responded.
>
> Is anyone aware if the advisor can be turned off (or more importantly back
> on) for a library?
>
> Customer is experiencing performance issue but it ain't hardware. 5
> Power8 cores at low utilization hundreds of GB of memory with low faulting,
> SSD Storage with mostly sub ms response time but queries that run for 90 or
> more seconds.
>
> IBM i 7.1 current PTFs. Using the Navigator for i interface. QAQQINI is bone
> stock.