I'm not sure why you would have to rely on CQE? They are 2 different
query engines but the results are the same...just faster with SQE. I'm
just not sure how this would break your apps. Anyway you can update
QAQQINI where QQPARM='IGNORE_DERIVED_INDEX' and set it to *NO



From: <franz400@xxxxxxxxxxxx>
To: midrange-l@xxxxxxxxxxxx,
Date: 03/30/2012 06:59 AM
Subject: How to force sql CQE instead of SQE V6r1
Sent by: midrange-l-bounces@xxxxxxxxxxxx



Loaded recent ptfs & DB2 group. v6r1
Now many that used to go thru CQE using SQE.
This broke some apps & need a quick way to
get a production app to use CQE.
These are Windows client .net and some of the sql joins
are huge and ugly.
Have no maintenance window to back down.
Specify logical file in sql no longer forces CQE.
Jim

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].