[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Reducing the physical size of SYSTEM (AREV Specific) ====
=== At 04 MAY 2003 11:10:33AM Ray Martini wrote: ===
 
{{tag>"AREV Specific"}}
 
<QUOTE>
My SYSTEMP is using over 32 million bytes.



I've done a CLEARTABLE and even a FIX with the option to compress empty overflow frams, but the file size remains the same size.



What can I do so the physical file size is shrunk and I can gain back some of my disk space?  I have an ongoing problem with my physical disk volume constantly running low on disk space.
</QUOTE>
----

=== At 04 MAY 2003 12:16PM Richard Hunt wrote:  ===

<QUOTE>Ray,



The CLEARTABLE should have worked. It should have reduced the size of the LK file to 1024 bytes and the OV file to 0 bytes.



You might want to check the SIZELOCK and verify it to be 0. You can use DUMPLH to modify the sizelock.



Once the SIZELOCK is 0 the CLEARTABLE should work.

</QUOTE>

----

=== At 04 MAY 2003 07:02PM Paul Rule wrote:  ===

<QUOTE>Once the sizelock is zero, if it still doesn't resize, do a manual compress from dumplh. Press Ctrl-C.

</QUOTE>

----

=== At 06 MAY 2003 04:57PM Jocelyn Amon wrote:  ===

<QUOTE>In my experience, the only method of compacting a file is to remake it - you are asked to give the number of records and average record size. The system can then recreate it at its optimum size.



In Arev 2 the command is: REMAKEFILE

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=2CC64642396B5B1C85256D1C00535D29|View this thread on the  forum...]]