Re: sort files in /tmp

Ye Olde Bouncing Mail Syndrome. > > I have noticed large srt* files showing up in the /tmp directory of > Informix Online 5.0. > > The manual says they are temporary sort files. Under what circumstances > are they created? Why don't they get removed? Are they kept with the > idea that another query may need to use them? > > How do people normally clean them up? Is a cron job that removes srt* > files that haven't been modified or accessed in the last 30 minutes a > solution? > I would say that are older than 1 day. These are indeed temp files from queries (ORDER BY). If you abort the query they are left. Problem is if you have queries that run more than 30 minutes (heaven forbid) you will trash them by rm'ing the files. cheers j. _____________________________________________________________________________ Jack Parker | Hewlett Packard, BSMC Boise, Idaho, USA| So many windows, jparker@hpbs2561.boi.hp.com | so little time. (208) 396-5388 (W) (208) 384-1623 (H) | _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________