Re: Informix corrupted file .... help
Path: emory!att!att!cbnewsk!jfv From: jfv@cbnewsk.att.com (j.f.van valkenburg) Newsgroups: comp.databases Summary: Have you tried Keywords: sysmenu.dat Message-ID: <1991Aug14.212440.27005@cbnewsk.att.com> Date: 14 Aug 91 21:24:40 GMT References: <1991Aug14.035416.6269@unislc.uucp> Organization: AT&T Bell Laboratories In article <1991Aug14.035416.6269@unislc.uucp>, mrc@unislc.uucp (Mike Cederholm) writes: > I am trying to help a lady (64 yrs old no kidding) to restore a data base > application which was written in Informix for Xenix 286. The data has been > recovered and represents a lifetime of geneological research in England. > Her program is almost all back together after much piecing and lots of > gluing (ha, ha - I can laugh now, but it has been a night mare...). The > remaining piece is the user menus as defined in sysmenu.dat and sysmenu.idx > files. These files are corrupt and giving me lots of grief. Without them I > will lose the user defined menus and functions she originally had. I am not > sure that I can trash them and keep the database from coming apart... > > Can anyone help ???| > Thanks, > unislc!mrc@sun.com > > +=======================================================================+ > Mike Cederholm dba. | (801)-254-7039 > pineHOUSE Development | (801)-594-4460 @ Unisys,SLC > 1246 Lampton Rd. | > So. Jordan, Utah 84065-9218 | > +=======================================================================+ > uucp: unislc!mrc@sun.com > internet: still working on it.. > +=======================================================================+ Depending on which version of INFORMIX SQL you have, have you tried doing an unload of the data in sysmenus and sysmenuitems. You might also try doing a table repair on these two tables, this might help. I have found in the past that as a last resort, doing an unload, then droping the two tables, and recreating everything over again, table wise, and loading the data back works. ------------------------ James F. Van Valkenburg a.k.a. "van" AT&T Attmail: !jfv jfv@cbnewsk.att.com Atlanta, GA. Voice 404-810-7920 =============================================================================== ---- Standard Disclaimers included -- Just another grunt at AT&T ---- ===============================================================================