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



We're at V5R4.




                                                                           
             "Bruce Barrett"                                               
             <bruce.barrett@pm                                             
             igroup.com>                                                To 
             Sent by:                  "Midrange Systems Technical         
             midrange-l-bounce         Discussion"                         
             s@xxxxxxxxxxxx            <midrange-l@xxxxxxxxxxxx>           
                                                                        cc 
                                                                           
             10/02/2006 12:56                                      Subject 
             PM                        RE: Impact of QAQQINI setting       
                                       IGNORE_DERIVED_INDEX=*YES           
                                                                           
             Please respond to                                             
             Midrange Systems                                              
                 Technical                                                 
                Discussion                                                 
             <midrange-l@midra                                             
                 nge.com>                                                  
                                                                           
                                                                           




What version of the O/S are you running?  On V5R3 I loaded PTF MF38886
to correct the solution of the engine choice.
We had a SQL statement running 204 seconds before this PTF and 3 to 4
seconds after.

Bruce Barrett

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

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of darren@xxxxxxxxx
Sent: Monday, October 02, 2006 7:08 AM
To: midrange-l
Subject: Impact of QAQQINI setting IGNORE_DERIVED_INDEX=*YES


I recently did a little fancy footwork with the QAQQINI file so that I
could temporarily set the IGNORE_DERIVED_INDEX setting to *YES.  This
was
necessary to cause IBM's enhanced query engine (SQE) to be used where I
had
derived logicals built against a physical file, and I wanted to do some
SQE
only functions.  My question is, what if I make this
IGNORE_DERIVED_INDEX
*YES permanent.  I was initially afraid of bad query performance, but
through some experiments, it seems rare that the query optimizer ever
picks
a "derived index" type logical anyway.

I guess, my more specific question is, under what conditions will the
query
optimizer pick a "derived index" since my initial experiments show it
not
picking it, despite constructing a logical that should have chosen the
derived index.

The bulk of the offending logicals are DDS built for our BPCS ERP
system.
They are often used to control soft-deleted records.

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


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