RE: Index Advisor

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.