SQL/MP Installation and Management Guide

Moving a Database
HP NonStop SQL/MP Installation and Management Guide—523353-004
9-37
Renaming or Renumbering Your System
Purging Detached SQL Objects (Step 8)
Run the Guardian DSAP utility with the SQL option to determine if your node has
detached SQL objects:
22> DSAP $volume, SQL, DETAIL
Then use the SQLCI CLEANUP utility to purge any detached objects:
>> CLEANUP $volume.subvolume.object ! ;
For a description of the CLEANUP utility, see the SQL/MP Reference Manual.
Renaming or Renumbering Your System
Use the SYSGEN utility to rename or renumber your system.
Reinstalling SQL/MP on a Node
Make sure that the TMF subsystem has been brought back up and the appropriate
volumes have been enabled. Then re-create the system catalog and initialize SQL/MP
by following the instructions in Installing SQL/MP on page 2-2. The two steps are listed
briefly here:
1. Create the system catalog:
>> CREATE SYSTEM CATALOG catalog-name;
2. Initialize SQL/MP:
>> INITIALIZE SQL;
Restoring a SQL/MP Database on a Node
1. Re-create the SQL catalogs with the same security and ownership for the catalogs
and catalog tables using the SQLCI CREATE utility.
2. Use one of these:
•
Use TMF to recover all audited files except SQL catalog files using the
RECOVER utility.
•
Restore the SQL objects from the backup tape or disk files using the
RESTORE utility.
3. Restore SQL programs stored as Guardian files from the backup tape or disk files,
optionally with recompilation; for an SQL program stored in an OSS file, use the
appropriate OSS utility.
4. Make TMF online dumps of all restored audited objects.
5. Verify database consistency.