RE: Database is locked?

Posted in 2005

Murray Wood (IList) — Wed, 16 Feb 2005 08:56:28 +1300 — source: Usenet: comp.databases.informix

We had this a long time ago with 7.30 or 7.31 (there was a bug that sometimes logging mode change would not complete), so I presume you have an old version on 7.31. Talk to Tech Support, but I recall the solution for us was to rebuild sysmaster. If this is the case upgrade to to the current version of Informix 7.31.UD8. MW > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org] On Behalf Of Diveman > Sent: Wednesday, 16 February 2005 2:59 a.m. > To: informix-list@iiug.org > Subject: Database is locked? > > Hi guys, > > Can anyone help me to unlock a database in IDS 7.31? > I got this Error message: > > 329: Database not found or no system permission.> > 178: ISAM error: Database is locked; pending change to> logging mode. > Error in line 1 Near character position 22> > I have tried to unlock the database with: > > 1) ontape -s -L 0 > > 2) ontape -s -B <databasename> > > But the database is still locked after the Leve 0 archive dumps! > > It is also impossible to drop the database as long as it is locked,,,, > > Please advice!? > > /Diveman > > sending to informix-list