SQL/MP Installation and Management Guide

Moving a Database
HP NonStop SQL/MP Installation and Management Guide—523353-004
9-13
Moving the System Catalog
In the DROP command, sys-catalog is the volume and subvolume on which
your system catalog resides.
You cannot, however, enter the DROP SYSTEM CATALOG command while
SQLCI2 is running, as it normally is when you are running SQLCI and have
entered other commands during the current session. If you attempt to enter this
command in that case, the command terminates abnormally, and the RDBMS
returns an error message. So, you must exit from SQLCI, which implicitly
terminates SQLCI2. Next restart SQLCI and enter the DROP SYSTEM CATALOG
command at the first SQLCI prompt.
10. Create the new system catalog through SQLCI as follows:
>> CREATE SYSTEM CATALOG new-system-catalog;
In the command, new-system-catalog names the volume and subvolume on
which the new system catalog is to reside. The CATALOGS table will be created on
the same volume as the system catalog but on the SQL subvolume. For more
information on the CREATE SYSTEM CATALOG command, see the SQL/MP
Reference Manual.
11. Reinitialize SQL/MP through SQLCI as follows:
>> INITIALIZE SQL;
This operation renames ZZSQLCI2 to SQLCI2, compiles SQLCI2, and registers
the SQLCI2 program in the system catalog.
12. Rebuild the CATALOGS table unless the CATALOGS table does not contain any
entries or you do not have user catalogs, in which case, skip to Step 14 on page
9-14.
Add the entries to the CATALOGS table without affecting the dependent SQL
catalogs and objects. To accomplish this task, you must be using a licensed
SQLCI2 process, as described in Appendix A, Licensed SQLCI2 Process. After
setting up the licensed SQLCI2L process, use it to run the OBEY command file
(generated by the commands shown in Step 4
on page 9-10) to insert the catalog
entries into the CATALOGS table:
>> OBEY obey-insert-file;
Each INSERT statement in the file (for CATALOGS table versions 300 and later)
should look like this sample:
INSERT INTO new-catalogs-vol.$SQL.CATALOGS
VALUES ("\SYS1.$VOL4.INVENT ",
"SQL ",
"A345",
0,
"U",
345
) ;