Re: How long do you run between shutdowns

In article <Ct71Dt.Myq@cda.mrs.umn.edu>, markvo@cda.mrs.umn.edu (Mark Van Overbeke) says: >Here is a question. How long do you run between system shutdowns? > >What we have is a library automation system on this machine. Is there >any reason, from the database perspective, why the machine should/would >need to be rebooted on a daily, or every other day, schedule? I am not >very familiar with databases and how they operate so any info is greatly >appreciated. Thanks. We run very large databases 24 hours a day, and do not restart Unix or Informix OnLine but once a month, except for unscheduled outages (rare). Informix OnLine (with a correctly written application) can run longer than our Unix system. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~ Jim Burks jburks@promus.com ~ ~ Database Administrator / Systems Engineer ~ ~ The Promus Companies, Inc. Memphis, TN USA ~ ~ http://stargate.promus.com/public/jbb.html ~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~