HP 3000 Manuals HP 3000 Manuals
RECOVER
Performs maintenance on the ATCINFO file.
Syntax
RECOVER
Prerequisites
None.
Description
Use the RECOVER command to perform maintenance on the ATCINFO file. The
default name of the ATCINFO file is DBEnvironmentNameCR with up to six
characters of the DBEnvironmentName. Maintenance for the ATCINFO file
may be necessary in either of the following situations:
* If a crash occurs while the ATCINFO file is being modified. This
may be the case if a crash takes place when the IMAGE/SQL
administrator is in the midst of an IMAGE/SQL utility command that
updates the ATCINFO file. When this occurs, the RECOVER command
can be used to reconstruct the ATCINFO file.
* If the ATCINFO file contains too much free space. This may be the
case if multiple databases are attached and then some are detached
from the DBEnvironment. When this occurs, the RECOVER command can
be used to compact the data in the ATCINFO file and return the
free space to the file system.
Example
In the following example, the ATCINFO file associated with the PartsDBE
DBEnvironment (PARTSCR) is recovered.
____________________________________________________________________
| |
| >>SET SQLDBE PartsDBE |
| >>RECOVER |
| Checking physical file consistency and recovering free space.|
| Deleting unused mapped table entries. |
| Checking external cross references. |
| >> |
____________________________________________________________________