SQL/MP Installation and Management Guide

Moving a Database
HP NonStop SQL/MP Installation and Management Guide—523353-004
9-33
Backing Up and Purging SQL Objects
°
Using the MODIFY DICTIONARY utility to make the necessary changes, as
follows:
°
Use the MODIFY DICTIONARY CATALOG command to change node
names in catalogs on the local node.
°
Use the MODIFY DICTIONARY LABEL command to change node
numbers in file labels of SQL objects and SQL object programs on the
local node.
°
Use the MODIFY DICTIONARY REGISTER command to register a user-
defined catalog in the local system catalog.
•
Moving all SQL objects and all partitions of SQL objects from the affected node to
another node
The time needed to restore an SQL/MP database depends on the size of the database
and could be substantial. You can reduce the time by removing all unwanted SQL
objects before you back up the database.
Backing Up and Purging SQL Objects
Before renaming or renumbering a node, follow these steps to back up and purge SQL
objects. Each step is explained later in detail.
1. Find all the objects on the local node and on remote nodes that need to be backed
up.
2. Back up the SQL programs by using the appropriate utility depending on whether
the program is stored in a Guardian or OSS file.
3. Back up all other SQL objects except catalogs by using the BACKUP utility.
4. Create an OBEY command file that will re-create the catalogs with the same
ownership and security as the original catalogs and catalog tables.
5. Purge the SQL objects and programs.
6. Drop all user catalogs.
7. Back up and drop the system catalog, removing SQL/MP from the node.
8. Check for and purge any detached SQL objects (objects not registered in a
catalog).
Finding Objects to Be Backed Up (Step 1)
The SQL/MP system catalog contains the names of all catalogs on the node, in the
CATALOGNAME column of the CATALOGS table. Use the SQLCI FILEINFO
command to find the volume name of the system catalog:
>> FILEINFO $*.SQL.CATALOGS;