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



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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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.