HPlogo IMAGE/SQL Administration Guide: HP 3000 MPE/iX Computer Systems > Chapter 2 Using the IMAGE/SQL Utility

Task 16: Maintaining the ATCINFO File

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Glossary

 » Index

This task describes how to maintain the ATCINFO file.

Getting Ready

Maintenance for the ATCINFO file (DBEnvironmentNameCR) 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.

Performing the Task

To recover the ATCINFO file associated with the PartsDBE DBEnvironment, issue the following commands:

   :RUN IMAGESQL.PUB.SYS

   >>SET SQLDBE PartsDBE

   >>RECOVER

   Checking physical file consistency and recovering free space.

   Deleting unused mapped table entries.

   Checking external cross references.

   >>

Task Reference

  • For the syntax of the RECOVER command, refer to Chapter 4, "IMAGE/SQL Utility Commands."

Feedback to webmaster