<div> Well, there are over 8 million records in this file - so I was looking for a bit quicker of a solution to get this resolved</div>
<div> I can't wait to get this system on a CentOS server - SCO is soooooo dang slow haha</div>
<div> I'm currently looking to export the records to a few csv files, then delete key & data for this file and import only the most</div>
<div> recent 6 months or so and then resolve the rest when I get back next week from vacation....</div>
<div> Why do these things happen the day before I'm leaving town? haha</div>
<div> </div>
<div> So, to clarify - is this a SCO OpenServer 5.0.5 issue, or is this a filePro error? Meaning, if I upgrade tonight to 5.6.10 would this</div>
<div> resolve the issue?</div>
<div> </div>
<div><br><br> </div>
<div class="gmail_quote">On Thu, Feb 3, 2011 at 4:38 PM, Jeff Harrison <span dir="ltr"><<a href="mailto:jeffaharrison@yahoo.com">jeffaharrison@yahoo.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div>
<div></div>
<div class="h5">----- Original Message ----<br><br>> From: "<a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a>" <<a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a>><br>> To: filePro Mailing List <<a href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</a>><br>
> Sent: Thu, February 3, 2011 4:13:05 PM<br>> Subject: file too large<br>><br>> We have a note line file that has apparently surpassed the 2GB size on SCO<br>> OpenServer 5.0.5 running filePro 5.6.07R4<br>
> A lot of users got stuck recording new records to this file, so I got them<br>> all off the system and tried adding a record and I'm getting<br>><br>> ..../appl/filepro/filename: key file too large<br>
><br>> We had previously run an archive on this file, but I know filePro won't<br>> actually 'shrink' the file size reported on the file system.<br>><br>> Are there any utilties that will 'shrink' this file below the 2GB size limit<br>
> by 'removing blank records' ?<br>><br>> So much for my vacation that was supposed to start tomorrow........ uggghh<br>><br>><br>><br>> Scott<br><br></div></div>If your blank records are actually deleted records, then yes there are a number<br>
of utilities that can shrink your file. You can also do this yourself - just<br>archive all the remaining records to another (new) file (or qualifier in the<br>same file), and then from the OS just copy the key file back on top of the<br>
original key. Do the same for any other data segments that may exist. Then<br>rebuild all of your indexes in the original file and you should be all set.<br><br>One possible "gotcha" - sometimes people actually use the record numbers as<br>
pointers - I assume you are not doing that?<br><br>Going forward you may want to set up a periodic archive so this does not happen<br>again.<br><br>Good Luck.<br><font color="#888888"><br>Jeff Harrison<br>Author of JHExport and JHImport.<br>
<br><br><br></font></blockquote></div><br>