Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Hold file consuming a large amount of disk space
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Hold file consuming a large amount of disk space
 Login/Join
 
Gold member
posted
Hi All,

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 you

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8202
 
Posts: 61 | Location: India | Registered: March 24, 2014Reply With QuoteReport This Post
Guru
posted Hide Post
try FORMAT TAB in case you have large alfanumeric fields.


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
 
Posts: 441 | Location: Europe | Registered: February 05, 2007Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Developer

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: 1963 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
I think the better question is why are you bringing back 40GB of data.

Surely it could be summarised or filtered.

What is the data source ?


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: 6281 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport This Post
Gold member
posted Hide Post
Teradata is my data source


WebFOCUS 8202
 
Posts: 61 | Location: India | Registered: March 24, 2014Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Developer

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: 1963 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
With Terradata the source, you may be able to SAME_DB

This will create a temporary table and not return the data to WebFOCUS session.

I would suggest reviewing what your code is doing to minimise the size of the result set.

Also Teradata may not be set up to allow temp tables, your DB Admin can confirm.

Check the documentation.

ON TABLE HOLD [AS filename] FORMAT SAME_DB PERSISTENCE VOLATILE


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: 6281 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport This Post
Gold member
posted Hide Post
Thank you for guidance

Please let me know if i'm wrong

every time when report executed
at the end of the FOCUS code can i delete the hold file name from tempdir

-* Windows -WINNT Deleting hold file
DEL HLD_FIL.ftm


WebFOCUS 8202
 
Posts: 61 | Location: India | Registered: March 24, 2014Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Developer

Please look at my original answer. That file should be automatically deleted from the edatemp directory..


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1963 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Hold file consuming a large amount of disk space

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.