Re: ? Informix Error 397

James Maxwell wrote: > > I have a new Informix Database and I am having recurring sql error (sqlcode > = -397, > isam error =0) . Error refers to failures on sysprocplan and other database > operations. > The tbcheck on catelog , reserve pages, data rows, indexes etc do not show > any > problems. > Any help and comments on this will be greatly apprecited. I don't know how big your database is, but if you have tryed a tbcheck on the whole database with options cc, ce, cr & cID then I would dbexport and dbimport before you get any more corruption. Cheers, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+