Re: sql using cqe when qaqqini derived is specified

[CRPence <CRPbottle@xxxxxxxxx>]

  Does that mean to imply the users could not effect the override to 
the defaults [per an inability to effect CHGQRYA due to authority]?  If 
so, that seems in conflict with a claim to have "verified the QAQQINI 
used has the Ignore Derived Index specified."  Did I incorrectly infer 
what was the resolution, or what was the original problem, or could 
something else be offered to explain my confusion about what I inferred 
to be logically disjointed comments?

Regards, Chuck

On 27 Jun 2013 12:37, J Franz wrote:
> I get to answer my own posting....
> V6R1 updated via ptf new requirements for authorization for
> db2 requests and we had new users not in the group set up
> for this. We solved this a year ago, but not maintained.
> http://www-03.ibm.com/systems/resources/systems_i_db2_navigator_security_controls.pdf
>
> J Franz onThursday, June 27, 2013 12:36 PM wrote:
>
> > I can view the Visual Explain, see that CQE was used, reason is
> > Derived Key or Select/Omit Indexes, yet verified the QAQQINI used
> > has the Ignore Derived Index specified. <<SNIP>>