Re: Killing of sqlturbo
In article <C66sLz.Mw@rnihd.rni.sub.org> klaus@rnihd.rni.sub.org (Klaus Brand) writes: Path: mlc-ratingen.de!Germany.EU.net!mcsun!uknet!pipex!doc.ic.ac.uk!agate!howland.reston.ans.net!ira.uka.de!smurf.sub.org!rnihd!klaus From: klaus@rnihd.rni.sub.org (Klaus Brand) Newsgroups: comp.databases.informix Date: 28 Apr 93 09:20:22 GMT Organization: Research Center of German Telecom, Darmstadt Lines: 16 Hi Netlanders, i have a question about killing sqlturbo processes. What happens when I kill sqlturbo or sqlexec with a kill -9 ??? It might kill your database, as it killed ours :-( Our programmers did this very often when they were testing new applications using Informix Online 4.10. They did so until two weeks ago. Then a collegue killed an sqlturbo which was in a critical section. That crashed the whole online system, leaving the database corrupted. tbcheck didn`t help, we had to re-initialize and restore from backups. I told them to use tbmode -z instead. Sometimes it seems not to work, the sqlturbo still continues, I have been told. But as a last help you can always take the db offline :-) My only question: If an abnormal abortion of an sqlturbo corruptes the database, this might also occur in the case of a system crash or a power failure. Is this true? Are there any ways to repair the db instead of using a backup? Michael ------------------------------------------------------------------------------- M M L CCC | Michael Schunk | Tel: +49 2102/8506-0 MM MM L C | MLC Systeme GmbH & Co. KG | Fax: +49 2102/8506-30 M M M L C | Am Bruell 19 | Eunet: ms@mlc-ratingen.de M M LLLL CCC | W 4030 Ratingen (Germany) | ------------------------------------------------------------------------------- -- ------------------------------------------------------------------------------- M M L CCC | Michael Schunk | Tel: +49 2102/8506-0 MM MM L C | MLC Systeme GmbH & Co. KG | Fax: +49 2102/8506-30 M M M L C | Am Bruell 19 | Eunet: ms@mlc-ratingen.de M M LLLL CCC | W 4030 Ratingen (Germany) | -------------------------------------------------------------------------------