Re: Losing rows in a static table

David, Thanks for replying. Here are my answers below. Steve David Williams wrote: > In article <355C9A88.93563421@sccsi.com>, Steve Goldberg > <goldberg@sccsi.com> writes > >I am having a problem of losing, and sometimes adding, rows in a table > >that is used for read-only. > > > >We are under Sun 5.5.1, Online 7.20.UC2, I4gl 6.03.UC1. and > >SCO Openserver 5.0.2 Online 7.23.UC1, I4gl 6.04.UC1 > > > >We have a start_up database that we read to get a list of error messages > >to be saved in memory. We then open the "data" database, create a temp > >table and insert the error messages. The privledges on the > >start_up.err_table is informix has full, public has select only. The > > Does the application copy the table across every time it starts or > is this a once-ff copy? > This is done every time another user starts up the application. All day long. > >application starts in the "data" database, closes it, opens start_up, > >gets some housekeepping stuff, closes it and opens "data" again for the > >remainder of the session. > > > > I see so startup is a kind of configuration database?? Yep. > > > >On a active system, 200+users simultaneously, the err_table gets > >corrupted every 10 minutes. We have a cron job that counts the rows. If > >it is not the correct amount, we reload the table. > > > > Corrupted how? Do you get any Informix error messages back? > Does the online.log say anything? The number of rows in the table changes. Sometimes more and duplicated, sometimes fewer rows, and those may be duplicated. Online.log says nothing. > > > What happens if you > > oncheck -cID <database name>:<tablename>> > it? > > Also try > > oncheck -cr > oncheck -ce > oncheck -cc <database name> Haven't tried these, but it is a thought. But gut feeling will show nothing. > > > If these are ok, put triggers on the table to raise an exception if > a row is deleted... Another thought, now I'll have to learn triggers. <g> > > > >We have an open ticket with Informix Tech Support, but they have no > >history on this situation. Anybody else have seen this? > > > >TIA > >Steve Goldberg > >Landata RE-Source > >sgoldber@stewart.com > >goldberg@sccsi.com > > > > -- > David Williams > > Maintainer of the Informix FAQ > Primary site (Beta Version) http://www.smooth1.demon.co.uk > Official site http://www.iiug.org/techinfo/faq/faq_top.html > > I see you standin', Standin' on your own, It's such a lonely place for you, For > you to be If you need a shoulder, Or if you need a friend, I'll be here > standing, Until the bitter end... > So don't chastise me Or think I, I mean you harm... > All I ever wanted Was for you To know that I care