Informix loses data !

Hi all We,ve got Informix dynamic server (the one which comes with Netscape Suitespot) running on our intranet... Now we've got a slight little problem with it - it's losing existing data... Some records have suddenly dissapeared with no warnings... What might cause this kind of behaviour ? Has it something to do with the size of the database ? Any Ideas ? I'd like to get it fixed before any bigger damage happens... Markku ;-)

Markku Lahti wrote: > We,ve got Informix dynamic server (the one which comes with Netscape > Suitespot) running on our intranet... > > Now we've got a slight little problem with it - it's losing existing > data... > > Some records have suddenly dissapeared with no warnings... > > What might cause this kind of behaviour ? > Has it something to do with the size of the database ? > > Any Ideas ? > > I'd like to get it fixed before any bigger damage happens... Is that the LiveWire Pro stuff? That's a little ancient these days, but it still shouldn't be losing data. On the other hand, I'm not sure that it will be regarded as fully Y2K-compliant, either. What platform? How do you know it is losing data? Are you sure someone isn't deleting it for you? Are you using raw disk files or cooked chunks? Do you have a transaction log on your database? -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.95 -- see http://www.perl.com/CPAN #include <disclaimer.h>

In article <38D08A88.8A5DF72B@earthlink.net>, Jonathan Leffler <jleffler@earthlink.net> wrote: > Markku Lahti wrote: > > > We,ve got Informix dynamic server (the one which comes with Netscape > > Suitespot) running on our intranet... > > > > Now we've got a slight little problem with it - it's losing existing > > data... > > > > Some records have suddenly dissapeared with no warnings... > > > > What might cause this kind of behaviour ? > > Has it something to do with the size of the database ? > > > > Any Ideas ? > > > > I'd like to get it fixed before any bigger damage happens... > > Is that the LiveWire Pro stuff? That's a little ancient > these days, but it still shouldn't be losing data. On > the other hand, I'm not sure that it will be regarded as > fully Y2K-compliant, either. > > What platform? How do you know it is losing data? Are > you sure someone isn't deleting it for you? Are you using > raw disk files or cooked chunks? Do you have a transaction > log on your database? > > -- > Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) > Guardian of DBD::Informix v0.95 -- see http://www.perl.com/CPAN > #include <disclaimer.h> > > Never worked with > Informix dynamic server (the one which comes with Netscape) but it could be a RollBack It's the only way to see record disapare without warning will you think they are there. -- Sent via Deja.com http://www.deja.com/ Before you buy.

Hi Jonathan Leffler wrote: > Markku Lahti wrote: > > > We,ve got Informix dynamic server (the one which comes with Netscape > > Suitespot) running on our intranet... > > > > Now we've got a slight little problem with it - it's losing existing > > data... > > > > Some records have suddenly dissapeared with no warnings... > > > > What might cause this kind of behaviour ? > > Has it something to do with the size of the database ? > > > > Any Ideas ? > > > > I'd like to get it fixed before any bigger damage happens... > > Is that the LiveWire Pro stuff? That's a little ancient > these days, but it still shouldn't be losing data. On > the other hand, I'm not sure that it will be regarded as > fully Y2K-compliant, either. > Yes it's LiveWire and it should be y2k compliant (manufacturers words) > > What platform? How do you know it is losing data? Are > you sure someone isn't deleting it for you? Are you using > raw disk files or cooked chunks? Do you have a transaction > log on your database? > We have UNIX with HP 10.20 (server sw NES 3.6) About 30 old records dissappeared somewhere... They couldn't be found either via our web-application nor dbaccess utilities... Not knowing when or where... This database is only in use for a limited group of people, who shouldn't be deleting their own work... Data is in raw-disk files We dont have Transaction log It has not done this recently, actually this happened in November 1999.... (with NES 2.1) This problem disappeared in December 1999, when we took a new server and server SW (updating NES to 3.6) to use... I'm just worried that it would happen again, and trying to get some help to avoid it beforehand... Markku ;-) > -- > Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) > Guardian of DBD::Informix v0.95 -- see http://www.perl.com/CPAN > #include <disclaimer.h>

Whenever my users have accused the system of changing/deleting data on its own the change has proved to have been done by a user! Use triggers to update audit tables. Oh the satisfaction of pointing the finger, IT WAS YOU BOY, YOU DELETED THE DATA Haahhhaaaaaaaaaa Sorry, forgot my dried frog pills this morning :o) -- --------------------------------------- Tony Flaherty aef@mfs.misys.co.uk Analyst Programmer Misys Financial Systems All statements and opinions are my own, Misys don't pay me enough to have opinions on their behalf . Markku Lahti wrote in message <38D0A6A7.49F5967B@nokia.com>... >Hi > >Jonathan Leffler wrote: > >> Markku Lahti wrote: >> >> > We,ve got Informix dynamic server (the one which comes with Netscape >> > Suitespot) running on our intranet... >> > >> > Now we've got a slight little problem with it - it's losing existing >> > data... >> > >> > Some records have suddenly dissapeared with no warnings... >> > >> > What might cause this kind of behaviour ? >> > Has it something to do with the size of the database ? >> > >> > Any Ideas ? >> > >> > I'd like to get it fixed before any bigger damage happens... >> >> Is that the LiveWire Pro stuff? That's a little ancient >> these days, but it still shouldn't be losing data. On >> the other hand, I'm not sure that it will be regarded as >> fully Y2K-compliant, either. >> > >Yes it's LiveWire and it should be y2k compliant (manufacturers words) > >> >> What platform? How do you know it is losing data? Are >> you sure someone isn't deleting it for you? Are you using >> raw disk files or cooked chunks? Do you have a transaction >> log on your database? >> > >We have UNIX with HP 10.20 (server sw NES 3.6) >About 30 old records dissappeared somewhere... >They couldn't be found either via our web-application nor dbaccess >utilities... >Not knowing when or where... >This database is only in use for a limited group of people, who shouldn't >be deleting their own work... >Data is in raw-disk files >We dont have Transaction log > >It has not done this recently, actually this happened in November 1999.... >(with NES 2.1) >This problem disappeared in December 1999, when we took a new server and >server SW (updating NES to 3.6) to use... > >I'm just worried that it would happen again, and trying to get some help >to avoid it beforehand... > >Markku ;-) > > >> -- >> Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) >> Guardian of DBD::Informix v0.95 -- see http://www.perl.com/CPAN >> #include <disclaimer.h> >

Markku Lahti wrote: > > > > What platform? How do you know it is losing data? Are > > you sure someone isn't deleting it for you? Are you using > > raw disk files or cooked chunks? Do you have a transaction > > log on your database? > > > > We have UNIX with HP 10.20 (server sw NES 3.6) > About 30 old records dissappeared somewhere... > They couldn't be found either via our web-application nor dbaccess > utilities... > Not knowing when or where... > This database is only in use for a limited group of people, who shouldn't > be deleting their own work... > Data is in raw-disk files > We dont have Transaction log This could be the cause of the problem. If you have added or updated rows, do not have a logged database using unbuffered logging, and take a system crash, it is possible that you will lose data or updates. This can occur because the changes exist only in the buffer. Have you had any crashes or power failures??? > > It has not done this recently, actually this happened in November 1999.... > (with NES 2.1) > This problem disappeared in December 1999, when we took a new server and > server SW (updating NES to 3.6) to use... > > > I'm just worried that it would happen again, and trying to get some help > to avoid it beforehand... > > Markku ;-) > > > -- > > Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) > > Guardian of DBD::Informix v0.95 -- see http://www.perl.com/CPAN > > #include <disclaimer.h>

If you have logging turned on, you could examine your old logs to determine responsibility. This can be quite a painful process but it is doable. If you know approximately when the rows went missing, examine your message log to determine which specific log(s) you need to look into. Read the FM on "onlog". Rudy Markku Lahti wrote: > Hi all > > We,ve got Informix dynamic server (the one which comes with Netscape > Suitespot) running on our intranet... > > Now we've got a slight little problem with it - it's losing existing > data... > > Some records have suddenly dissapeared with no warnings... > > What might cause this kind of behaviour ? > Has it something to do with the size of the database ? > > Any Ideas ? > > I'd like to get it fixed before any bigger damage happens... > > Markku ;-)

Poor transaction handling?? Trigger somewhere??? Cascading delete??? Markku Lahti wrote: > > Hi all > > We,ve got Informix dynamic server (the one which comes with Netscape > Suitespot) running on our intranet... > > Now we've got a slight little problem with it - it's losing existing > data... > > Some records have suddenly dissapeared with no warnings... > > What might cause this kind of behaviour ? > Has it something to do with the size of the database ? > > Any Ideas ? > > I'd like to get it fixed before any bigger damage happens... > > Markku ;-) -- Paul Watson # WF Software Ltd # You are only young once Tel: +44 1436 674729 # but you can be immature Fax: +44 1436 678693 # for ever www.wfsoftware.com #

>Subject: Informix loses data ! >From: Markku Lahti spammia.kiitos.ei.markku.o.lahti@nokia.com >Date: 16.03.00 07:03 W. Europe Standard Time >Message-id: <38D07A03.9FCA18A0@nokia.com> > >Hi all > >We,ve got Informix dynamic server (the one which comes with Netscape >Suitespot) running on our intranet... > >Now we've got a slight little problem with it - it's losing existing >data... > >Some records have suddenly dissapeared with no warnings... > >What might cause this kind of behaviour ? >Has it something to do with the size of the database ? > >Any Ideas ? > >I'd like to get it fixed before any bigger damage happens... > >Markku ;-) > > > > > What are the version numbers of the products used? The Informix engine does not just loose data, you are most likely loosing transactions. Nona

Markku Lahti <spammia.kiitos.ei.markku.o.lahti@nokia.com> a écrit dans le message news:38D0A6A7.49F5967B@nokia.com... <snip> > We have UNIX with HP 10.20 (server sw NES 3.6) > About 30 old records dissappeared somewhere... > They couldn't be found either via our web-application nor dbaccess > utilities... > Not knowing when or where... > This database is only in use for a limited group of people, > who shouldn't be deleting their own work... ^^^^^^^^^^^^^^^^^^^^^^ At the risk of sounding sarcastic HAW HAW! I think that's your explanation right there! How many times have you deleted something by mistake and been 100% convinced that the computer was broken because your data disappeared? Or do your team never make tyops? I know I do... <snip> > We dont have Transaction log ^^^^ This would tend to indicate that your data is not particularly important. If you can't be bothered with logging I would suggest frequent back-ups. -- Andrew Pearson - un animal avec beaucoup de fonctions interactives. Parlez et riez ensemble. Il connait 800 mots et bruits. Réagit à la lumière et au bruit. Ses mouvements sont très réalistes! Version anglaise.

Thank You all for Your answers. I'll check all things You have suggested and come back later with this issue if needed... Markku ;-) Markku Lahti wrote: > Hi all > > We,ve got Informix dynamic server (the one which comes with Netscape > Suitespot) running on our intranet... > > Now we've got a slight little problem with it - it's losing existing > data... > > Some records have suddenly dissapeared with no warnings... > > What might cause this kind of behaviour ? > Has it something to do with the size of the database ? > > Any Ideas ? > > I'd like to get it fixed before any bigger damage happens... > > Markku ;-)