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,

try FORMAT TAB in case you have large alfanumeric fields.

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.

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 ?

Teradata is my data source

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?

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

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

Developer

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