RE: reorg HUGE file

[Scott Mildenberger <Smildenber@xxxxxxxxxxxx>]

We have this product and it works great.  We had files with 10 million
deleted records that are used 7 x 24 and cannot be changed to reuse deleted
records.  Our downtime was only a minute or so.

Scott Mildenberger

> -----Original Message-----
> From: Mark Phippard [mailto:MarkP@softlanding.com]
> Sent: Tuesday, February 27, 2001 8:30 AM
> To: MIDRANGE-L@midrange.com
> Subject: RE: reorg HUGE file
> 
> 
> 
> You should look at TurnOver PDQ.  http://www.softlanding.com/
> 
> With this product, you can reorganize a file while it is 
> still being used,
> so you do not have to worry about how long the process takes 
> to complete.
> The same product can be used when you want to install a change to a
> database file.
> 
> Hope this helps,
> 
> Mark Phippard
> Director of Development
> SoftLanding Systems
> 
> 
> 
> 
>                                                               
>                                                        
>                     "Fisher, Don"                             
>                                                        
>                     <DRF@HeiligMeyers.c        To:     
> "'MIDRANGE-L@midrange.com'" <MIDRANGE-L@midrange.com>         
>                     om>                        cc:            
>                                                        
>                     Sent by:                   Subject:     
> RE: reorg HUGE file                                      
>                     owner-midrange-l@mi                       
>                                                        
>                     drange.com                                
>                                                        
>                                                               
>                                                        
>                                                               
>                                                        
>                     02/27/01 08:19 AM                         
>                                                        
>                     Please respond to                         
>                                                        
>                     MIDRANGE-L                                
>                                                        
>                                                               
>                                                        
>                                                               
>                                                        
> 
> 
> 
> 
> We recently went through this with a file containing 152 
> million records,
> of
> which 107 million are deleted (neither number is a typo).  We 
> attempted to
> reorganize the file using RGZPFM, but were forced to cancel 
> the job after
> three days.
> 
> So we ran an experiment using a CPYF to another library and 
> then another
> CPYF back to a copy of the original file with the three logical files
> including the members.  This process consumed only seven and 
> a half hours.
> 
> In a few weeks, we intend to try this with the real thing.
> 
> We are running a dual processor model 640 at V4R1.
> 
> Hope that helps.
> 
> Donald R. Fisher, III
> Project Manager
> Heilig-Meyers Furniture Company
> (804) 784-7500 ext. 2124
> Don.Fisher@HeiligMeyers.com
> 
> 
> -----Original Message-----
> From: D.BALE@handleman.com [mailto:D.BALE@handleman.com]
> Sent: Monday, February 26, 2001 7:47 PM
> To: MIDRANGE-L@midrange.com
> Subject: reorg HUGE file
> 
> 
> I've got a file with 40 million records, 10 million of which 
> are deleted.
> The
> file is over 14 GB.
> <clip>
>
+---
| 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
+---