Re: System slow-down - disk usage?

[Luis Rodriguez <luisro58@xxxxxxxxx>]

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


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

> Thanks Luis, read that, implementing DDL as a replacement for DDS, not
> removing any RLA for the most part...but I was asking about SETLL vs.
> CHAIN,
> not RLA vs. SQL or DDS vs. DDL...
>
> Or, did I miss something else that was buried in that doc (which pre-dates
> the addition of RCDFMT for DDL and therefore gives the, IMO, wrong advice
> on
> how to move to DDL for RLA)...
>
> Crispin.
>
> ----- Original Message -----
> From: "Luis Rodriguez" <luisro58@xxxxxxxxx>
> To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
> Sent: Thursday, June 17, 2010 2:05 PM
> Subject: Re: System slow-down - disk usage?
>
>
> Crispin,
>
> Check this, I think it could be of help.
>
>
> http://www-03.ibm.com/systems/resources/systems_i_software_db2_pdf_Performance_DDS_SQL.pdf
>
> <
> http://www-03.ibm.com/systems/resources/systems_i_software_db2_pdf_Performance_DDS_SQL.pdf
> >
> 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.