RE: SFL Load - SQL vs. LF

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.