RE: Reorg of large file

["Shaw, David" <dshaw@xxxxxxxxxxx>]

Martin,

1) If you don't reorg the file, you will gain zero space in it by deleting
the records.  You will get back space in any logicals built over it when
they are updated: immediately if they are MAINT(*IMMED), whenever they're
rebuilt if they're MAINT(*REBUILD), and whenever they get brought up to date
if they're MAINT(*DLY) (note that until they're brought up to date, there
will be update information stored for MAINT(*DLY) paths which will actually
take up MORE space).

2) Reorg time is not predictable from the information you've given.  I
believe IBM has a web page (perhaps in Technical Studio?  I can't remember
now) which specifies how to estimate the time.  I've never used it, though,
so I can't speak to its accuracy.  Note that if you plan to delete the
records and then do the reorg before letting people back into the files,
better performance will be achieved if you delete all logical access paths
or change them to MAINT(*REBUILD) BEFORE you start deleting the records - no
point in updating access paths that you're just going to rebuild as part of
the reorg anyway.

Dave Shaw
Spartan International, Inc.
Spartanburg, SC
---
If you would like to subscribe to the MAPICS-L mailing list send email to
MAPICS-L-SUB@midrange.com or go to www.midrange.com and follow the
instructions.

-----Original Message-----
From: Saunders, Martin P [mailto:Martin.Saunders@capgemini.co.uk]

All,

We have a file (approx 46 million records).  We are going to archive and
delete approx. half of these.  The file is just over 7 gig in size and is
REUSEDLT *No.

How much space are we likely to gain by deleting the records but not
reorganising the file?

How long is reorganising the file likely to take?

AS/400 is a 9406 530 at V4R3 with 160 gig of disk and 2 gig of memory.

Thanks in advance for any answers,

Martin
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---