Reducing the physical size of SYSTEM (AREV Specific)
At 04 MAY 2003 11:10:33AM Ray Martini wrote:
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.
At 04 MAY 2003 12:16PM Richard Hunt wrote:
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.
At 04 MAY 2003 07:02PM Paul Rule wrote:
Once the sizelock is zero, if it still doesn't resize, do a manual compress from dumplh. Press Ctrl-C.
At 06 MAY 2003 04:57PM Jocelyn Amon wrote:
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