Previous Topic: Non-DBUTLTY BackupsNext Topic: Restoring a Damaged Index


Backing Up Compressed Data Areas (Physical Sequence, UPDATE=NO)

When backing up compressed data areas, if the area is being updated, records may move from one disk location to another and can be duplicated or lost. To prevent this from occurring, use the DBUTLTY LOCK and UNLOCK functions. The LOCK function prevents records from moving until the UNLOCK is issued. First, issue the lock, run the backup, and then issue the unlock. UPDAT requests that cause records to move wait for the unlock. For more information, see LOCK (Lock a Data Area) and UNLOCK.

This procedure assumes only one MUF instance is enabled when the lock is issued. If there is more than one MUF instance that can open the area for update, lock each MUF intance. No protection is provided if a MUF is disabled at the time of the lock, then subsequently enables and opens the area for update while the backup is in process.