Re: sqlrpgle select statements

We had similar issue. A query that use to take 5 min would take hours to
finish when we moved to V5R3. The problem was a SELECT/OMIT logical file.
We worked with IBM for a couple of months and the solution/work around they
came up with was adding IGNORE_DERIVED_INDEX  set to *YES in QAQQINI file or
specifying logical file in your select statement.


"Alan Shore" <AlanShore@xxxxxxxx> wrote in message
news:OF43BABB0D.8F4C5639-ON85257125.004D0D20-85257125.004D404D@xxxxxxxxxxx

One reason that I would recommend in using a(n) LF in a  SELECT/FROM, is
the SELECT/OMIT's within the DDS of the LF.  This might be the reason "why
in the world _some_ SELECTs will run in a fraction of the time when an LF
is named instead of the PF"


Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx



             qsrvbas@netscape.
             net
             Sent by:                                                   To
             rpg400-l-bounces@
rpg400-l@xxxxxxxxxxxx
             midrange.com                                               cc

                                                                   Subject
             03/01/2006 08:26          RE: sqlrpgle select statements
             PM


             Please respond to
              RPG programming
              on the AS400 /
                  iSeries
             <rpg400-l@midrang
                  e.com>






rpg400-l-request@xxxxxxxxxxxx wrote:

>   3. AW: sqlrpgle select statements (HauserSSS)
>
>You should NEVER use a logical file in an SELECT-Statement!
>The query dispatcher that decices which query engine will be used, will
>reroute all SQL-Statements that use a logical file to the Classic Query
>Engine (CQE). This rerouting will cost up to 10% of performance.


Although I won't recommend specifying the LF name in a SELECT/FROM, this
does bring up the question of why in the world _some_ SELECTs will run in a
fraction of the time when an LF is named instead of the PF.

I would expect that the answer would be found within DB2 group PTFs, but I
don't really know.

Tom Liotta

--
Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone  253-872-7788 x313
Fax    253-872-7904
http://www.powertech.com


__________________________________________________________________
Switch to Netscape Internet Service.
As low as $9.95 a month -- Sign up today at
http://isp.netscape.com/register

Netscape. Just the Net You Need.

New! Netscape Toolbar for Internet Explorer
Search from anywhere on the Web and block those annoying pop-ups.
Download now at http://channels.netscape.com/ns/search/install.jsp
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.




----------------------------------------------------------------------------
----


> -- 
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>