Just the physical. The command is Reorganize Physical File Member (RGZPFM).
On 1/5/06 04:25 PM, "Brian Piotrowski" <bpiotrowski@xxxxxxxxxxxxxxx> 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
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-
>
>
