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

Chris Bipes wrote:

> IMHO that is why IBM gave us the RCLSTG command.  Next IPL, run it and then
> look at those files.  By the way, Reuse Deleted Records adds lots of
> overhead to the data base manager, (searching for deleted records), and that
> is why IBM does not use it on system files.  I suppose you can change them
> but It will/may affect your entire systems performance.
>
> Be Careful,
>
> 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 1:09 AM
> To: MIDRANGE-L@midrange.com
> Subject: Question on Reorganizing IBM Files...
>
> Hi Folks !
>
> Doing "disk cleaning" and I have some programs that rat out files with
> deleted records. Along with our 3rd party software apps files I also
> have IBM files that show up on my "Files with Deleted Records in order
> of "biggest offenders" report:
> The top ones are:
>
> Cross Reference Physical Files:
>
> QSYS/QADBIFLD has 273,940 active records and 1,410,315 deleted records
> !!
> QSYS/QADBKFLD has 18,824 active records and 42,115 deleted records.
>
> and then a BUNCH of other Cross Ref files that are not NEAR as
> "bloated"...
>
> OS/400 Document Library File
> QUSRSYS/QAOSSS14 has 2,919 active records and 19,625 deleted records.
>
> My question is can these things be reorged ? I know they are CONSTANTLY
> in use so it would have to be in restricted state. Or better YET, why
> doesn't IBM use the "Reuse deleted records" parameter ??? !!!
>
> 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
> +---

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