Re: System slow-down - disk usage?

Yes, I believe that is the case (and no, I don't want to restart any
"religious" wars either... :-) )

That said, please post your solution (if there is one). This is turning out
to be a very interesting thread (at least for me, who is not saddled with
the problem <g>).

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries


On Thu, Jun 17, 2010 at 3:08 PM, Crispin Bates <cbates@xxxxxxxxxxx> wrote:

Luis,

Not wanting to the the very old RLA vs. SQL discourse again, but surely
it's
already been argued that for a single fetch, RLA will almost always win,
right?

Crispin.

----- Original Message -----
From: "Luis Rodriguez" <luisro58@xxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Thursday, June 17, 2010 3:22 PM
Subject: Re: System slow-down - disk usage?


Crispin,

The link was sent only as a reference of the benefits of using DDL-defined
tables/indexes vs DDS defined ones. It seems that the performance gains
can
be quite significant and I thought this could be of interest in your
particular case.

On the other hand, I wonder what would happen if you substitute your
CHAIN/SETLL with a SQL SELECT?

And yes, the document is quite a bit dated, but most of the info is still
(I
believe) worth it.


Best Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries




--
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.