SQL/MP Installation and Management Guide

Performing Recovery Operations
HP NonStop SQL/MP Installation and Management Guide—523353-004
11-33
PUP FORMAT
2. Create an EDIT file containing CREATE CATALOG and ALTER TABLE statements
to re-create the catalogs and reset the security of the catalog tables.
3. Back up the volume by using a file-mode BACKUP command.
Next, use PUP RENAME to rename the disk. You might first want to label the disk with
PUP LABEL to clear all the old files.
Finally, restore the files as follows:
1. Re-create the catalogs on the renamed volume using the file created in Step 2 as
the input file for the SQLCI OBEY command.
2. Restore the volume, mapping the old volume names to the new volume names in
the RESTORE command. Map the objects to the new catalogs.
3. Verify the database by using the VERIFY utility; an example of the VERIFY
command follows:
>> VERIFY $VOL.*.*;
4. SQL compile all the programs with new DEFINEs to revalidate the programs.
PUP FORMAT
The PUP FORMAT command erases all the information on a disk volume. If a disk
volume is formatted, you must follow the same procedure as you would with the PUP
LABEL command.
PUP REMOVE and PUP REVIVE
You can use the PUP REMOVE command on a mirrored volume pair to make one half
of the pair inactive. The active disk drive of the mirrored pair continues to maintain the
current database, without the protection of mirroring.
After the disk drive is removed, you can bring the disk up as a phantom drive (without a
name), label the disk with another volume name, or reuse the disk in any other way.
This operation is often done on nodes where nonmirrored disk space is needed for a
short time.
Later, you can return the previously removed disk drive to its original mirrored state by
performing a PUP REVIVE.
You should not use the removed drive to store production SQL database files. You
typically use the drive for a test database or for temporary space for sort files. The use
of the drive must ensure that you can make the volume inactive and revive the drive
back to its original mirrored configuration with no effect on the original database.
PUP DOWN (or PUP REMOVE) and PUP UP
Use the PUP DOWN or PUP REMOVE command on a volume to put a particular
volume out of operation; you can later use the PUP UP command to put the same disk