Re: bcheck safety

Posted in 1999

Obnoxio The Clown — Tue, 21 Dec 1999 13:41:35 GMT — source: Informix-list mailing list archive (1991-1998)

From: Jailes <jaile.sebes@blr.sni.de> > > If i run bcheck on my C-ISAM filles >will it delete any of my valid data . What are the reasons for index >getting corrupted 1. No. It basically just drops and recreates indexes. 2. Any number of things: power dips, sun spots, radiation from mobile phones, flaky media, bugs... ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

↪ replying to Obnoxio The Clown

Art S. Kagel — Tue, 21 Dec 1999 14:39:24 -0500 — source: Informix-list mailing list archive (1991-1998)

Obnoxio The Clown wrote: > > From: Jailes <jaile.sebes@blr.sni.de> > > > > If i run bcheck on my C-ISAM filles > >will it delete any of my valid data . What are the reasons for index > >getting corrupted > > 1. No. It basically just drops and recreates indexes. > > 2. Any number of things: power dips, sun spots, radiation from mobile > phones, flaky media, bugs... Killing processes in the midst of updating rows, killing sqlexec processes anytime, system crashes (SE has no logging for recovery like IDS does) ... Art S. Kagel