Performs maintenance on the ATCINFO file.
Syntax |
 |
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.
>>
|