Re: System slow-down - disk usage?

[Luis Rodriguez <luisro58@xxxxxxxxx>]

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.