RE: Physical and Logical File Reorganizing Questions

["Brian Piotrowski" <bpiotrowski@xxxxxxxxxxxxxxx>]

Great, I appreciate all of the input from everyone.

Brian.

-----Original Message-----
From: Don Tully [mailto:dtully@xxxxxxxxxx] 
Sent: Friday, January 06, 2006 5:15 AM
To: Midrange Systems Technical Discussion
Subject: RE: Physical and Logical File Reorganizing Questions

Bryan,

You should definitely consider the "Reuse deleted records" option on the
PF.
I have used that feature for more than 10 years and thus have needed to
reorg very few files over that time.  This will only cause problems when
relative record number processing (non keyed) is required.

Don Tully
Tully Consulting LLC

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Brian Piotrowski
Sent: Thursday, January 05, 2006 3:25 PM
To: Midrange Systems Technical Discussion
Subject: Physical and Logical File Reorganizing Questions


Hi All,



When I'm performing a reorganize on files, do I need to do it on both
the physical and logical files, or only on the physical file?



Let's say I have three files in the system:



ABC123 - PF (1000 records)

ABC123A - LF (250 records)

ABC123B - LF (95 records)



I deleted 50 records out of ABC123 (950 records remaining).  Of those 50
records deleted, 25 of them were also in ABC123A and 5 records were also
in ABC123B.



Two questions:



1) If the same records were contained in the LFs (as indicated by 25 and
5 respectively), will they be updated by having the records deleted out
of them as well?

2) If #1 is yes, do I need to perform a reorganize on the logical files
too?



The reason I'm asking is that we have several physical files (and many
more child LFs) that need to be pruned every few months or they hog disk
space like crazy.  I'm going to rewrite our quarterly batch job to clean
up these files, and I want to ensure that all files will be cleaned.



Thanks!


Brian.



-=-=-=-=-=-=-=-=-=-=-=-=-=-

Brian Piotrowski

Specialist - I.T.

Simcoe Parts Service, Inc.

PH: 705-435-7814

FX: 705-435-6746

-=-=-=-=-=-=-=-=-=-=-=-=-=-



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.