Re: Physical and Logical File Reorganizing Questions -- MIDRANGE-L

The way I think of it is this: Physical files hold the actual data,Logical files are really just a file of addresses from the physicalfile, in the order needed for the logical. Logical files hold no actualdata.

The Operating System's file handler keeps all that straight for you, soif you deal with the physical files, you should be all right.



Brian Piotrowski wrote:

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

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