RE: QAQQINI

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

Be careful when handling the QAQQINI.  Always use CRTDUPOBJ to make a
clone into another library.  If you create a clone in QUSRSYS, this
essentially becomes the default query options file.  Cloned QAQQINI
files in other libraries can be used when a job issues a CHGQRYA
command, setting the "Query options file library" (QRYOPTLIB) parameter.

Google QAQQINI V5R4 (or whatever release you run).  Everything you need
is in "Control queries dynamically with the query options file
QAQQINI"...

Hth,
-Eric DeLong

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of David FOXWELL
Sent: Thursday, November 12, 2009 8:02 AM
To: Midrange Systems Technical Discussion
Subject: QAQQINI

All,

Having some performance problems : 

Visual explain says CQE used because of derived key or select/omit.
Got rid of all select/omit LFs.
Created all advised indexes.

In STRSQL I get the message in the log <impossible to extract the
request options file>

QAQQINI only exists in QSYS. The message says to create the file in
QUSRSYS or indicate where to find it. 

1. I can't copy from QSYS because of authority.
2. How do I indicate another library?
3. Does not having the file result in IGNORE_DERIVED_INDEX *yes or *no ?

Here's my request :

SELECT * FROM
clients join clientaddress on clients.client_id =
clientaddress.client_id        
Join
addresses on clientaddress.address_id=addresses.address_id

WHERE avil like 'PARIS%'

                   
Could someone explain exactly what is meant by <derived> index?

Thanks.