Hi, how do I release the unused space after a REBUILD REBUILD or a REBUILD REORG.This message has been edited. Last edited by: <Kathryn Henning>,
WebFOCUS 8.2 Windows, All Outputs
July 13, 2014, 05:35 PM
Waz
You may have to do a REBUILD DUMP and REBUILD LOAD, as I don't think the REBUILD and REORG options delete the FOC file.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
July 14, 2014, 03:31 AM
Alan B
The spaces taken by a FOCUS db is not automatically reclaimed.
You can backup the FOCUS db, issue a REBUILD REORG DUMP, delete the FOCUS db, issue USE and CREATE FILE, and then issue a REBUILD REORG LOAD.
Alan. WF 7.705/8.007
July 14, 2014, 06:59 AM
Pauline in Germany
Thanks for the answers but my problem is that I don't seem to be able to delete the file between the DUMP & LOAD steps. ERASE doesn't work. Is there another way of physically deleting a file from within a procedure.
WebFOCUS 8.2 Windows, All Outputs
July 14, 2014, 07:28 AM
Alan B
Are you using the FDS for this file? Have you tried APP DELETEF?
Alan. WF 7.705/8.007
July 14, 2014, 05:42 PM
Waz
Where is the FOCUS file ?
And What is the OS, your signature states Windows
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
July 15, 2014, 07:30 AM
Pauline in Germany
Hi again
the answer for Alan is not that I know of and yes I have also tried APP DELETEF which also didn't work.
The answer for Waz is Unix box under z/OS
WebFOCUS 8.2 Windows, All Outputs
July 15, 2014, 05:41 PM
Waz
APP DELETEF should work, have you tried ! rm {path+filename} ?