Re: Data Purging - File Downsizing

You can use RGZPFM (Reorganize Physical File Member) then F4 prompt ..... 
but all users have to be out of the file. 

Micki Rogers, IT Director
Michigan Wheel Corporation
(616) 248-5317
mrogers@xxxxxxxxxxx



Al Mac <macwheel99@xxxxxxxxxxx> 
Sent by: bpcs-l-bounces+mrogers=miwheel.com@xxxxxxxxxxxx
03/06/2007 11:33 AM
Please respond to
SSA's BPCS ERP System <bpcs-l@xxxxxxxxxxxx>


To
"SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx>
cc

Subject
Re: [BPCS-L] Data Purging - File Downsizing






   I just purged some ancient records from several files & I forget some
   final cleanup how done.

   I have these files which have had stuff older than 2 years removed, so 
the
   actual data there is a fraction of the records volume that was there
   before, but they still eating the same disk space.

   What I want is to lower the actual disk space consumption, to that 
which
   agrees with # records in the file, without messing with the logicals or
   growth definitions.  Is there a standard OS/400 command that will do a
   reorg in place to accomplish that for me?  Or do I have to manually 
mess
   with change file, fingers crossed my arithmetic is correct, kill all
   logicals, copy file, regenerate all logicals.

   We are BPCS 405 CD on AS/400 model 170 with V5R1.

   -
   Al Macintyre
   BPCS/400 Computer Janitor ... see
   http://radio.weblogs.com/0107846/stories/2002/11/08/bpcsDocSources.html