IBM Support

You try to connect to a database but see errors 329 and 178

Technote (troubleshooting)


Problem(Abstract)


You try to connect to a database but see errors 329 and 178:

-329 Database not found or no system permission.
-178 ISAM error: Database is locked; pending change to logging mode.

Cause

A request has been made to change the logging status of a database.
Until a level-0 archive is done for all the storage spaces that the
database uses, access to the database is blocked.

Resolving the problem

Take a level 0 backup. If you cannot take a backup for some reason you can try to cancel the logging mode change by running this command:

ondblog cancel yourdatabasename

Document information

More support for: Informix Servers

Software version: 10.0, 11.1, 11.5, 11.7, 11.70, 12.1

Operating system(s): AIX, HP-UX, Linux, OS X, Solaris, Windows

Reference #: 1642380

Modified date: 2014-06-26