Re: Reusing deleted records

["James W. Kilgore" <qappdsn@xxxxxxx>]

Al,

Thanks for the insight into this.  It just didn't make sense to me that a 
deleted
record map would be carried with the ODP and not shared among all jobs.

As you pointed out, JOBA gets the map, JOBB may retrieve the same map then start
deleting records.

Since the information available to JOBA is no longer current/accurate I am left
wondering what purpose it serves.  JOBC could be writing records into some of
these spaces so JOBA couldn't rely on the map to expedite writes.

Besides, IMHO this belongs in the domain of the underlying RDBMS and isn't any
business of a particular job.

It just strikes me odd that seemingly worthless information would be a part of 
an
ODP.  Multiply it by the number of ODP's per job and the number of jobs on the
system some real memory space starts to add up.

After I read your post yesterday I just thought OK, but it gnawed at me.  (BTW,
I'm going to the bank and checking out a loan in order to buy a life <G>)

Maybe you can fill me in on what purpose the deleted record map then serves as a
part of each ODP?

Thanks again

James W. Kilgore
qappdsn@ibm.net

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---