Re: Reusing deleted records

["Al Barsa, Jr." <barsa2@xxxxxxx>]

At 11:40 AM 9/23/98 -0700, you wrote:
>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?

I didn't design the function, I have merely studied it.  Whereas the
existing design may not be perfect, it does work and work well.

Al




+--------------------------------------------------+
| Please do not send private mail to this address. |
| Private mail should go to barsa@ibm.net.         |
+--------------------------------------------------+

Al Barsa, Jr. - Account for Midrange-L
Barsa Consulting, LLC.  
400 > 390

Phone:  914-251-9400
Fax:    914-251-9406


+---
| 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
+---