Re: QAQQINI

[Luis Rodriguez <luisro58@xxxxxxxxx>]

Davi
Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries

1. AFAIK, the recommend procedure is to leave QSYS's QAQQINI intact
and use it in another lib.
2. CHGQRYA

. IIRC, derived key means that the key was the result of an
expression. Sometimes it depends (I think) of the sort sequence either
of your files and in your STRSQL command (SRTSEQ). Again, IIRC, avoid
using *LANGIDSHR.

Regards,

Luis Rodriguez

On Thu, Nov 12, 2009 at 9:31 AM, David FOXWELL <David.FOXWELL@xxxxxxxxx> 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.
> --
> 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.