Re: File Reorg - Cons

[fiona.fitzgerald@xxxxxxxxxxxxxxxxxx]

OSD (OS Director) also handles this well.
It allows you to schedule the file reorgs after hours
- if a reorg would take too long, it doesn't run it.

Considerations;
Reorging a file doubles the size of the file while the process runs (a copy
is created in QTEMP).
Usually it's done when %age used disk space is already high.
It can take hours to complete, depending not only on the file size
but also on the amount of access paths.
And to interrupt a reorg can damage the object.

Or a cheap alternative would be to CPYF filename to copy COMPRESS(*YES)
Compress out deleted records.
CLRPFM the file, then CPYF copy to filename.

Fiona Fitzgerald



                                                                                
                         
                      PaulMmn                                                   
                         
                      <PaulMmn@xxxxxxxxxxx         To:      
midrange-l@xxxxxxxxxxxx                      
                      om>                          cc:                          
                         
                      Sent by:                     Subject: Re: File Reorg - 
Cons                        
                      midrange-l-bounces@m                                      
                         
                      idrange.com                                               
                         
                                                                                
                         
                                                                                
                         
                      28/04/04 04:44                                            
                         
                      Please respond to                                         
                         
                      Midrange Systems                                          
                         
                      Technical Discussion                                      
                         
                                                                                
                         
                                                                                
                         




THIS MESSAGE ORIGINATED ON THE INTERNET - Please read the detailed
disclaimer below.
-----------------------------------------------------------------------------------


Lakeview Technology (of Mimix fame) offers a product that allows you
to reorganize a file while things are live... all it takes is disk
space at least as big as the original file.  The file is reorganized,
along with its logical views.  At a Magic Moment when all activity
against the file has ended, the application swaps out the old file
with the deleted records, and swaps in the shiny new reorganized copy.

It works very well.

--Paul E Musselman




__________________________________

Notice of Confidentiality 

This transmission contains information that may be confidential and that may 
also be privileged. Unless you are the intended recipient of the message (or 
authorised to receive it for the intended recipient) you may not copy, forward, 
or otherwise use it, or disclose it or its contents to anyone else. If you have 
received this transmission in error please notify us immediately and delete it 
from your system.

Email: internet.mail@xxxxxxxxxxxxxxxx