Release 10.1A: OpenEdge Data Management:
Database Administration

> ## PROSTRCT UNLOCK qualifier

> Allows you to access a damaged database structure and correct inconsistencies between the creation date and the open date in the database file header block and the master block. This is especially useful when trying to force open a database or when recovering a lost database file.

> Caution: Use this utility as a last resort. Call Technical Support for further direction.

> #### Syntax

>     prostrct unlock db-name  [ -extents ]

> #### Parameters

> ``db-name``

> Specifies the database where you want to force access.

> ``-extents``

> Replaces missing extents with empty extents if any database files are missing.

> #### Notes

> - When the database finds an inconsistency among the data and recovery log, it generates an error message and stops any attempt to open the database. Typically, inconsistencies between files are a result of accidental misuse of operating system copy utilities, deletion mistakes, or incorrectly administered backup and restore procedures.

> - If the first data file (.`d1`) is missing, the database cannot open because of the missing master block. PROSTRCT UNLOCK with the `-extents` parameter, however, creates an empty file with the same name and location as the missing file that allows the database to open. This function helps enable access to a severely damaged database.

> - PROSTRCT UNLOCK does not repair damaged databases. It opens databases with inconsistencies in dates and missing extents, but these databases still need to be repaired before they can be used. For information on repairing databases, see the "Restoring a database" section.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095