RE: Question on Reorganizing IBM Files...

[Chris Bipes <chris.bipes@xxxxxxxxxxxxxxx>]

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