Re: QAQQINI

David

*http://tinyurl.com/yczxth7 is a link to all the information about this control file (v5r3 version - every release has similar information). Read this and YOU can be the expert!! :-)

Seriously, that is the best source of information.

The options in the file differ from release to release of the OS. You can't restore one from V5R1, e.g., to a later release - it will not be used. SQL will not fail but will not use the settings from the INI file.

There is also a QAQQINI builder online at **http://tinyurl.com/bhbrj - at this time it is limited to V5R4, but I have a feeling one could use that one on later releases, it just might not get newer options modified. They'd still be in the QAQQINI, just using defaults.

**Vern
*
David FOXWELL wrote:

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.