Previous Topic: Data AreasNext Topic: Access the Database


Manage the CA Datacom/AD Database

The methods to back up and recover the database in CA 7 Version 12.0 are different from the methods of previous releases. Studying the Backup and Recovery Considerations chapter in the Systems Programming Guide is critical to determining what type of backup and recovery processes meet your needs.

One major difference that is highlighted here is the creation of recovery files. Automating the creation of recovery files is an important part of managing your Version 12.0 database. CA Datacom/AD records information about table updates in its Log Area (LXX). The LXX is a fixed-sized file that is written to in a wrap-around fashion.

When all the table updates in an LXX block are committed, the block becomes spillable. Spillable means that the block is no longer needed for the transaction backout and can be written to the recovery file (RXX). After an LXX block has been spilled, it can be overwritten with new log data.

During the CA 7 installation, the LOGRCV setting is set to LOGRCV NO. This setting means that no dedicated tape drive is reserved for CA Datacom/AD to use for automatically spilling blocks from the Log Area (LXX) to the recovery file (RXX). Instead, a SPILL job must be periodically run. The job writes spillable LXX blocks to the recovery file and makes the spilled LXX blocks eligible for reuse. This process is known as inactive recovery.

Warning! You must spill the LXX often enough to ensure that space is always available to record new update information. If the LXX becomes full, all CA 7 activity stops until you run a SPILL job to free up blocks for reuse.

Note: For more information about spilling, see the Logging section in the Backup and Recovery Considerations chapter in the Systems Programming Guide.