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
> [mailtowner-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