At 10:34 AM 2/26/2015, Jan Johansen wrote:
Razzak,
Ok. In my case I can't do that as people are accessing Oterro during
web sessions.
I have noticed a whole lot of .$$$ files as well that I occasionally
need to clean
up.
I can't place your suggestion anywhere (I think) as these are web
sessions but the
sessions are definitely not exiting cleanly.
Jan,
Sure you can!
Using the provided solution, the command will ONLY delete .$$$, if un-locked,
and not being used by any session of R:BASE/Oterro, without ant
-ERROR- message.
If you didn't know already, or have not paid attention, a "unique" 32
character
file is created by each session of R:BASE eXtreme 9.5 and Oterro 9.5 engines.
Additional files are created and automatically deleted when using a huge query,
select, sort, or when managing TEMPORARY tables/views.
However, keep doing what you are already doing to occasionally need
to clean up.
For the web sessions, knowing the exact folder of your default/scratch .$$$
files, you may create a batch file to delete *.$$$ and run under MS
Windows Task
Scheduler, even in a MS Cloud environment.
That is your tip of the day!
Have fun!
Very Best R:egards,
Razzak
