Oninit cdi / Archive
Talk to an expert →

Re: Recycling Informix

Posted in 1999

Topics: Performance & Tuning, Jobs, Consulting & Announcements

Luse Harold — — source: Informix-list mailing list archive (1991-1998)

On Wed, 8 Dec 1999, Henderson, Scott wrote: > Informix Version: 7.30 FC7 > OS: HPUX 11.0 > Hardware: HP9000 Series 800 V2500 > Application: OLTP (strictly database server) > Misc. 16 CPU, 8GB mem, 2 instances > > > Folks, > > Quick question. > > What is your view regarding recycling the instance. One of our production > servers has been up for 30 days. Performance does not appear to be > degrading. I say leave it up. Only because I don't have a good argument not > to. > > We have an Informix consultant on site who believes we should bounce every > week (good salesman), "because it is a good business practice" "a good gut > feeling". (Rudy, you know who I'm talking about?). It may very well be > that we should bounce weekly but I would like some hard evidence that this > is "... good business practice" > > Thanks, > > Regards, > Scott Henderson > Database Administrator, IS Computing Services > ________________________________ > Tel: (905) 712-1084 ext. 3740 > Fax: (905) 712-6709 > e-mail: shenderson@purolator.com > ________________________________ > Purolator - THIS WAY TO FASTER, EASIER SHIPPING > > > We leave ours up for 5 to 6 weeks with no noticable degedation in performance. Usually after 5 to 6 weeks the Unix OS crashes taking Informix with it. ==================================================================== Harold Luse Phone: (970) 491-4120 Veterinary Teaching Hospital Fax: (970) 491-4123 Colorado State University Pager: (970) 229-8173 Fort Collins, Colorado USA E-mail: hluse@vth.colostate.edu ====================================================================

↪ replying to Luse Harold
elmo@iii.org.tw — — source: Informix-list mailing list archive (1991-1998)

Luse Harold <hluse@vth.colostate.edu> wrote: [snip] > We leave ours up for 5 to 6 weeks with no noticable degedation in > performance. Usually after 5 to 6 weeks the Unix OS crashes taking > Informix with it. Have you considered whether you should migrate to Windows NT? Just kidding. :) I'm curious what caused your Unix to crash. I've never run Informix under Windows NT, only under Solaris/Sparc. If my experience of Notes under Windows NT is any indication, it should run for months without any babysitting(There are only Lotus Notes and Symantec Anti-Virus on that server). On the other hand, our Informix sometimes crashes under unexpected conditions. For example, it once crashed when a statement "insert into table select * from another_table." It turned out that though the twotables have the same columns, the order of two columns were swapped. This is a progrmming error, indeed, not Informix's fault. Chih-Cherng Chin elmo@iii.org.tw

↪ replying to Luse Harold
Eric The Half A Bee — — source: Informix-list mailing list archive (1991-1998)

In article <82mqih$ibe$1@news.xmission.com>, Luse Harold <hluse@vth.colostate.edu> wrote: > > On Wed, 8 Dec 1999, Henderson, Scott wrote: > > > Informix Version: 7.30 FC7 > > OS: HPUX 11.0 > > Hardware: HP9000 Series 800 V2500 > > Application: OLTP (strictly database server) > > Misc. 16 CPU, 8GB mem, 2 instances > > > > > > Folks, > > > > Quick question. > > > > What is your view regarding recycling the instance. One of our production > > servers has been up for 30 days. Performance does not appear to be > > degrading. I say leave it up. Only because I don't have a good argument not > > to. > > > > We have an Informix consultant on site who believes we should bounce every > > week (good salesman), "because it is a good business practice" "a good gut > > feeling". (Rudy, you know who I'm talking about?). It may very well be > > that we should bounce weekly but I would like some hard evidence that this > > is "... good business practice" > > > > Thanks, > > > > Regards, > > Scott Henderson > > Database Administrator, IS Computing Services > > ________________________________ > > Tel: (905) 712-1084 ext. 3740 > > Fax: (905) 712-6709 > > e-mail: shenderson@purolator.com > > ________________________________ > > Purolator - THIS WAY TO FASTER, EASIER SHIPPING > > > > > > > > We leave ours up for 5 to 6 weeks with no noticable degedation in > performance. Usually after 5 to 6 weeks the Unix OS crashes taking > Informix with it. > > ==================================================================== > Harold Luse Phone: (970) 491-4120 > Veterinary Teaching Hospital Fax: (970) 491-4123 > Colorado State University Pager: (970) 229-8173 > Fort Collins, Colorado USA E-mail: hluse@vth.colostate.edu > ==================================================================== > > I'm not sure this comes under the heading of "good business practice" - more giving the DBA a warm feeling that, as Madison said, "I can do it". We certainly bounce the engine once a week for that very reason. We also have SCO OpenServer 5.0.4 (unintentionally) bounce it for us - although this is hopefully) a temporary thing, as SCO chooses its times less well than we do ! Regards Glyn Balmer -- If it always works, why don't parachutists pull the emergency 'chute first? Sent via Deja.com http://www.deja.com/ Before you buy.