Database access error.

Posted in 2000

Ron Schwingel — Mon, 10 Jan 2000 15:03:26 -0700 — source: Informix-list mailing list archive (1991-1998)

I get the following error when trying to select or drop a Database: 311: Cannot open system catalog (systables). 172: ISAM error: Unexpected internal error Does anyone know how I can fix this? Ron C. Schwingel, QuipWare Technical Group NDS Solutions Phone: (303) 755-4411 Fax: (303) 755-4545 Email: rschwing@ndsltd.com <mailto:rschwing@ndsltd.com>

↪ replying to Ron Schwingel

Jonathan Leffler — Tue, 11 Jan 2000 06:06:14 GMT — source: Informix-list mailing list archive (1991-1998)

Ron Schwingel wrote: > I get the following error when trying to select or drop a > Database: > > > 311: Cannot open system catalog (systables). > 172: ISAM error: Unexpected internal error> > Does anyone know how I can fix this? It implies that there is a serious problem with the database. A database without SysTables is not a functional database. If this is SE, then simply finish removing the database directory and the other files in it (if any). If this is OnLine, start looking to your archives to restore; you might be able to pull some amazing stunt with oncheck, but I have my doubts. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.95 -- see http://www.perl.com/CPAN #include <disclaimer.h>

Glossary

ISAM error