Hi All,

May be a silly one, but would really like to know the difference between these two temporary storages. When the temporary hold/save files goes to ts000551 and to foccache?
/ibi/srv77/wfs/edatemp/ts000551 and /ibi/srv77/wfs/edatemp/foccache.

I understand, during the session it keeps the data/foc file under 'ts000551' folder and in 'foccache' for 180 mins by default.

We had a situation, temporary .ftm/.foc files occupies the space in GB's when running the particular report, which results in filling up the file system to 100%. What is the steps to overcome this?

This message has been edited. Last edited by: <Emily McAllister>,

Hi

1. By default when you issue ON TABLE HOLD AS ABC, the foctemp or other format temporary file will be generated during the session under the edatemp/tsnnnn directory. These files should be deleted automatically when the report is finished. There are cases in which these files will not be deleted, in certain abnormal terminations of the reports or if you issue the SET TEMPERASE=OFF command which keeps these files (used for debugging)

2. Temp files will be created in foccache if you specifically refer to this location either by issuing APP HOLD FOCCACHE or ON TABLE HOLD AS FOCCACHE/ABC. In addition creating AHTML output with the foccache option (issuing the webviewer on command ). Foccache is used when you want to use the same hold files between several different reports (for example for drill downs) as long as the user is working in the same browser session.

3. Regarding the creation of huge ftm or foc files - you should debug your query regarding its performance and optimization, does WF create optimize SQL? Where are aggregations and groupings done ? on the Database or do you retrieve a lower granularity of data to WF and then create the aggregations and groupings of the WF side? Are Joins between tables being passed correctly to the DB or done by WF ?
Joins, Filters , aggregations and groupings should be performed on the source DB, then sending back to WF the respective result set for further analysis.

Yours

Eran

This message has been edited. Last edited by: WF_IL,

Thanks Eran for your explanations, I've no idea on the report part and managing the infrastructure here.
When they run the particular report, tsnnnnn entries keeps increases which results occupies the space allotted to file systems.