Re: Cleaning $DBTEMP??

Posted in 1997

Peter Lancashire — Mon, 06 Oct 1997 15:25:30 +0100 — source: Informix-list mailing list archive (1991-1998)

relay009@hotmail.com wrote: > > I am right in thinking that I can delete > everything from $DBTEMP in Informix as long > as know one is logged into the system, aren't I? > Please email - relay009@hotmail.com > > -------------------==== Posted via Deja News ====----------------------- > http://www.dejanews.com/ Search, Read, Post to Usenet This is SE I presume. You don't have your log in there, do you? You should get temp tables, *.dat and *.idx files. A safer solution is to run a daily cleanup job overnight with cron. Get it to remove files not accessed in N days. Make sure the backup system does not access files before the cleanup gets to them. Peter -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc.