Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Freeing up unused space after a REBUILD

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Freeing up unused space after a REBUILD
 Login/Join
 
Member
posted
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
 
Posts: 13 | Registered: June 05, 2014Report This Post
Expert
posted Hide Post
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.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Virtuoso
posted Hide Post
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
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Report This Post
Member
posted Hide Post
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
 
Posts: 13 | Registered: June 05, 2014Report This Post
Virtuoso
posted Hide Post
Are you using the FDS for this file?
Have you tried APP DELETEF?


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Report This Post
Expert
posted Hide Post
Where is the FOCUS file ?

And What is the OS, your signature states Windows


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Member
posted Hide Post
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
 
Posts: 13 | Registered: June 05, 2014Report This Post
Expert
posted Hide Post
APP DELETEF should work, have you tried ! rm {path+filename} ?

Also do you get an error, and if so what is it ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Virtuoso
posted Hide Post
Permissions?


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Freeing up unused space after a REBUILD

Copyright © 1996-2020 Information Builders