HP 3000 Manuals

RECOVER [ HP IMAGE/SQL Administration Guide ] MPE/iX 5.0 Documentation


HP IMAGE/SQL Administration Guide

RECOVER 

Performs maintenance on the ATCINFO file.

Syntax 

RECOVER

Prerequisites 

None.

Description 

Use the RECOVER command to perform maintenance on the ATCINFO file.
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 is recovered.
____________________________________________________________________
|                                                                  |
|     >>SET SQLDBE PartsDBE                                        |
|     >>RECOVER                                                    |
|     Checking physical file consistency and recovering free space.|
|     Deleting unused mapped table entries.                        |
|     Checking external cross references.                          |
|     >>                                                           |
____________________________________________________________________

            



MPE/iX 5.0 Documentation