Focal Point
[CLOSED] Hold file consuming a large amount of disk space

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3477042396

April 27, 2020, 07:00 AM
Developer
[CLOSED] Hold file consuming a large amount of disk space
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
April 27, 2020, 10:07 AM
Frans
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.
April 27, 2020, 10:18 AM
FP Mod Chuck
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
April 27, 2020, 05:28 PM
Waz
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!

April 28, 2020, 03:41 AM
Developer
Teradata is my data source


WebFOCUS 8202
April 28, 2020, 02:09 PM
FP Mod Chuck
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
April 28, 2020, 05:30 PM
Waz
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!

April 29, 2020, 07:52 AM
Developer
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
April 29, 2020, 10:28 AM
FP Mod Chuck
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