× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.