file too large

[Jeff Harrison]

----- Original Message ----

> From: "scooter6 at gmail.com" <scooter6 at gmail.com>
> To: filePro Mailing List <filepro-list at lists.celestial.com>
> Sent: Thu, February 3, 2011 4:13:05 PM
> Subject: file too large
> 
> We have a note line file that has apparently surpassed the 2GB size on  SCO
> OpenServer 5.0.5 running filePro 5.6.07R4
> A lot of users got stuck  recording new records to this file, so I got them
> all off the system and  tried adding a record and I'm getting
> 
> ..../appl/filepro/filename:   key  file too large
> 
> We had previously run an archive on this file,  but I know filePro won't
> actually 'shrink' the file size reported on the file  system.
> 
> Are there any utilties that will 'shrink' this file below the 2GB  size limit
> by 'removing blank records' ?
> 
> So much for my vacation that  was supposed to start tomorrow........  uggghh
> 
> 
> 
> Scott

If your blank records are actually deleted records, then yes there are a number 
of utilities that can shrink your file.  You can also do this yourself - just 
archive all the remaining records to another (new) file (or qualifier in the 
same file), and then from the OS just copy the key file back on top of the 
original key.  Do the same for any other data segments that may exist.  Then 
rebuild all of your indexes in the original file and you should be all set.

One possible "gotcha" - sometimes people actually use the record numbers as 
pointers - I assume you are not doing that?

Going forward you may want to set up a periodic archive so this does not happen 
again.

Good Luck.

Jeff Harrison
Author of JHExport and JHImport.