RE: Create DDL from exiting PF&LFs

Dmitri,

How about random reads?

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Dimitri Efimov
> Sent: Tuesday, July 05, 2005 11:16 AM
> To: Midrange Systems Technical Discussion
> Subject: RE: Create DDL from exiting PF&LFs
> 
> 
> 
> Joe, Jon,
> 
> thanks for comments.
> 
> I did some tests, trying to get performance boost from SQL 
> created files ...
> 
> No success as yet (I was experimented with the file with 
> decimal and character fields, 5 millions records, unique 
> index of decimal field, RPG program setll and read 100 record 
> starting from random key x 100k = 10 millions reading in total).
> 
> There are a couple of good points:
> 1. write and update operations don't slow down.
> 2. the file created with the same structure (using Ted Holts 
> tool) has the same member's identification level (no 
> recompilation needed for RPG programs)
> 
> >From the other side, for our bosses IBM has a reputation as 
> a hairiest level of IT consultant, so I just have implement it.
> 
> Dmitri Efimov
> 
> 
> 
> 
> 
> 
> -----Mensaje original-----
> De: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]En nombre de Jon Paris
> Enviado el: Domingo, 03 de Julio de 2005 01:16 p.m.
> Para: midrange-l@xxxxxxxxxxxx
> Asunto: RE: Create DDL from exiting PF&LFs
> 
> 
> Thanks for the reference Joe.
> 
> It is an interesting article and answers a number of 
> questions relating to
> some of the rumors floating around that I hadn't had time to 
> check out.
> 
>   >> The old-style DDS files do the checking on the read.
> 
> This is the only problem I have with the piece.  As far as I 
> know the DB
> does not do any checking.  The application itself simply 
> "blows up" when
> attempting to use the bad data.  That's why COBOL apps don't 
> suffer as badly
> as RPG from DD errors - if they don't touch the field they 
> don't blow up.
> RPG on the other hand moves every field from the buffer to its storage
> location.  It is that move that causes the explosion on the read.
> 
> I do agree though that having it done on the write is great - 
> wonder what
> error RPG signals if the data is bad?  I'll write a test case 
> sometime when
> I have 5.
> 
> 
> Jon Paris
> Partner400
> 
> www.Partner400.com
> www.RPGWorld.com
> 
> 
> --
> 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.
> 
> 
> Aviso Banco Wiese Sudameris
> 
> Este mensaje es privado y confidencial y solamente para la
> persona a la que va dirigido. Esta sujeto a los terminos que
> aparecen en  http://www.bws.com.pe/aviso.shtml los cuales
> forman parte de su contenido.
> 
> -- 
> 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.
> 
>