RE: SQL REUSEDLT

[Kurt Anderson <kurt.anderson@xxxxxxxxxxxxxx>]

Jorge - I think when you do a CHGPF on a SQL created file it is no longer treated as SQL created.  Not 100% on that, but I thought I came across that somewhere.

Rob - good questions.  I was asking because I wanted to know what my options are.  There is concern in the shop about reusing deleted records.  While I'm not sure of their reasons, there is a performance consideration.  Reusing deleted records results in a "nominal" performance hit, but nominal adds up when batch processing millions of records (in this case it's doubtful that there'd be millions of deleted records - although I don't know if the nominal hit is in regard to hitting the Deleted Record Map before performing the write or in the reuse of the deleted record itself).

Dennis - thanks for the info.

-Kurt

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Thursday, February 11, 2010 2:10 PM
To: Midrange Systems Technical Discussion
Subject: Re: SQL REUSEDLT

Why would you not want it to?  Are you relying upon arrival sequence?  Can 
you bypass that by adding a "sequence" column to the table?  If you're 
concerned about sequence rollover, log a date along with the sequence. 
That should work unless you plan on rolling over your sequence in the same 
day.


Rob Berendt