SQL/MP Installation and Management Guide

Moving a Database
HP NonStop SQL/MP Installation and Management Guide—523353-004
9-14
Moving Database Objects
Each INSERT statement in the file (for CATALOGS table earlier than version 300)
should look like this sample:
INSERT INTO new-catalogs-vol.$SQL.CATALOGS
VALUES ("\SYS1.$VOL4.INVENT ",
"SQL ",
"A011",
0,
"U"
) ;
13. Drop the licensed SQLCI2L process so that you cannot mistakenly use the
process. You should also drop the DEFINE for the SQLCI2L file. These commands
accomplish these operations:
>> EXIT;
28> DELETE DEFINE =_SQL_CI2_sys
29> SQLCI
>> DROP PROGRAM $SYSTEM.SYSTEM.SQLCI2L;
In the DELETE DEFINE command, sys is the node (system) name
without the backslash.
14. If you backed up any SQL objects in Step 2 on page 9-9, restore them to the new
system catalog by specifying the CATALOG option pointing to the new system
catalog:
30> RESTORE $TAPE, *.*.* CATALOG new-system-catalog,
AUDITED, OPEN, LISTALL
In the RESTORE command, new-system-catalog is the volume and
subvolume on which your system catalog resides.
Moving Database Objects
You can move individual SQL objects such as tables, views, indexes, and SQL
programs stored in Guardian files separately. Usually the dependent objects
(shorthand and protection views and indexes) are moved with the underlying table or
tables. Comments and constraints are automatically moved with a table.
The DUP and BACKUP/RESTORE utilities support the qualified file-set list to identify
the source file list. Qualified file-set list expressions enable you to refine the file set list
to specify objects. For information about the qualified file-set list, see DUP and
BACKUP/RESTORE on page 9-4. For a more thorough definition of a qualified file-set
list, see the SQL/MP Reference Manual.
You can move both audited and nonaudited objects either with DUP or with BACKUP
and RESTORE. Whenever you move any audited objects, you should include steps to
make TMF online dumps of all restored audited objects following the move. The online
dumps give the TMF subsystem the current location of the objects for file recovery.