Re: Losing rows in a static table

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? >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?? >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? What happens if you oncheck -cID <database name>:<tablename> it? Also try oncheck -cr oncheck -ce oncheck -cc <database name> If these are ok, put triggers on the table to raise an exception if a row is deleted... >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