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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.
I have a issues Hold file consuming a large amount of disk space in temp folder "edatemp\ts000000" when report executed every time and sql result data create in hold file name "HLD_FIL" and the hold file name Create data more the 40GB and due this Hold file consuming a large amount of disk space
After SQl query executed
TABLEF ON TABLE HOLD AS HLD_FIL FORMAT ALPHA END -RUN
Hold files "HLD_FIL" are storing in this below path \\ibi\srv82\wfs\edatemp\ts000000
how to delete the hold file name "HLD_FIL" after report executed ever time
Thank youThis message has been edited. Last edited by: FP Mod Chuck,
WebFOCUS 8202
Posts: 61 | Location: India | Registered: March 24, 2014
Any hold fiie in edatemp should automatically disappear when the request is complete. You might want to check to make sure SET TEMPERASE=OFF is not coded somewhere like the edasprof.prf or some other profile as that will prevent them from being deleted. If you can't find that set anywhere you can do to the following to insure it happens is to set the agent_refresh setting to 1 on the reporting server console under Workspace / Data Services / DEFAULT.
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
Posts: 2128 | Location: Customer Support | Registered: April 12, 2005
Your original problem was why did the temp file stay around, did you solve that? I am curious as well why your report generates 40GB of data no one would possibly be able to consume that much information. Couldn't it be filtered down to a more usable size and then drill down for additional detail as necessary?
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
Posts: 2128 | Location: Customer Support | Registered: April 12, 2005