× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. September 2006

Re: Query engine question

If appropriate, try using a logical file name rather than the physical (if a select stmt). There has been some debate in prev posts, but I beleive it will always run the cqe. 
I can't test that now, but might be worth a try.
The Info Center V5R3 Query Engine Overview states:
For ease of use, the routing decision for processing the query by either CQE or SQE is pervasive and under the control of the system. The requesting user or application program cannot control or influence this behavior. 

jim franz
----- Original Message ----- From: "Bruce Barrett" <bruce.barrett@xxxxxxxxxxxx> 
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Friday, September 22, 2006 2:32 PM
Subject: Query engine question



Does anyone know how to force a system running at V5R3 to use the CQE
engine and not the SQE engine?  We have been working with IBM on this,
but our management is very concerned about how long this is taking to be
resolved.
We have an issue of when we process a SQL statement on our development
partition the SQL runs using the CQE engine and processes in 4 seconds.
When we process the exact same SQL statement on our production partition
the SQL uses the SQE engine and processes in 204 seconds.
We have also found in iSeries Navigator looking at the statistic
collections are different.  On development the collection is stale, on
production it is not stale.
We have verified each partition is at the same PTF level and group
level.  IBM said we seem to have found a bug for the engine selection.
Any help with this is greatly appreciated.

Bruce Barrett
PMI Mortgage Insurance Co.
3003 Oak Road
Walnut Creek, CA 94597
925-658-6152
510-520-4263 Cell
bruce.barrett@xxxxxxxxxxxx

This e-mail is confidential and may be privileged. If you are not the
intended recipient, please destroy this message and notify the sender.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list 
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 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].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.