MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » June 2013

Re: sql using cqe when qaqqini derived is specified



fixed

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





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

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact