QAQQINI

[David FOXWELL <David.FOXWELL@xxxxxxxxx>]

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.