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


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.