Re: Query engine question

["Jim Franz" <franz400@xxxxxxxxxxxx>]

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.