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.

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>>

Return to Archive home page | Return to MIDRANGE.COM home page