RE: SFL Load - SQL vs. LF

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

See my previous post - check the I/O stats as presented by DSPFD before 
replacing DDS-based files with DDL-based ones. As with all performance 
suggestions, YMMV - and possibly widely. Don't assume your apps work the 
way someone assumes most do - you can check them out yourself.

Vern

At 06:22 PM 9/7/2005, you wrote:

> IBM has changed the data management rules for files created via DDL, which
> effective improves DB thruput for all applications using the file.
> Performance gains come from where IBM has chosen to implement the data
> validation code.  Under DDS rules, data is validated when it is read from
> the disk, where DDL moves the validation to DB writes and updates.
>
> The theory is that a typical application will read data much more than it
> writes data.  If we validate on write, then we've reduced IO overhead.
>
> iSeriesNetwork had an article about this.....
>
> Eric DeLong
> Sally Beauty Company
> MIS-Project Manager (BSG)
> 940-297-2863 or ext. 1863
>
>
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of James H H Lampert
> Sent: Wednesday, September 07, 2005 1:09 PM
> To: Midrange Systems Technical Discussion
> Subject: Re: SFL Load - SQL vs. LF
>
>
> Billy Rowe <billyrowe@xxxxxxx> wrote:
> > No matter which presentation method you decide to you,
> > definitely create the tables/indexes/views with SQL.
>
> Why?
>
> --
> JHHL
> (who is much more fluent in DDS and OPNQRYF than with SQL)
> --
> 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.
>
>
> --
> 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.