Re: Reuse deleted records (was SQL vs DDS)

Colin Williams wrote:
> 
> Unfortunately, removing journalled changes in a live system is not
> always an option.
> 

True enough. If it is one record, then rekey may be an option. If it is
one hundred, a thousand, tens of thousands? I had a client on V2R3 on an
F02. NOT fast. But that did not stop a wayward program from generating
198,000 AR records for a single customer in the blink of an eye. 

Journalling was not just an option then.


-- 
===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified AS/400 Professional System Administrator
 -- IBM Certified AS/400 Professional Network Administrator

"The sum of all human knowledge is a fixed constant.
    It's the population that keeps growing!"
+---
| 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
+---