RE: Question on Reorganizing IBM Files...

[Chris Bipes <chris.bipes@xxxxxxxxxxxxxxx>]

Reuse deleted records adds overhead to the data base manager period.  All
files have this overhead whether IBM's, Package, or Yours.  We use it on all
transaction files that have a lot of records added/deleted daily.  Just plan
for the overhead on your system if you use heavily.  It will save those
nasty reclaims.



Christopher K. Bipes     mailto:ChrisB@Cross-Check.com
Sr. Programmer/Analyst   mailto:Chris_Bipes@Yahoo.com
CrossCheck, Inc.         http://www.cross-check.com
6119 State Farm Drive    Phone: 707 586-0551 x 1102
Rohnert Park CA  94928 Fax: 707 586-1884

If consistency is the hobgoblin of little minds, only geniuses work here.
Karen Herbelin - Readers Digest 3/2000


-----Original Message-----
From: Chuck Lewis [mailto:clewis@iquest.net]
Sent: Monday, July 10, 2000 4:16 AM
To: MIDRANGE-L@midrange.com
Subject: Re: Question on Reorganizing IBM Files...


Thanks Chris !

I guess I never really considered the RCLSTG command for this (Duh) until I
got
Rob's post !!

And I wasn't planning on changing IBM's files (I consider stuff like that a
no
no) but DO appreciate the explanation about how Reuse Deleted Records can
impact
system performance !!!

Would this (sys performance degradation) apply to 3rd party files or my own
or is
it more impacted by the usage level of a file ?

Thanks !

Chuck

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