SQL/MP Installation and Management Guide

Moving a Database
HP NonStop SQL/MP Installation and Management Guide—523353-004
9-11
Moving the System Catalog
For the CATALOGS table versions that are earlier than version 300, use this OBEY
command file:
If the CATALOGS table does not contain any entries or you do not have any user
catalogs, skip to Step 6 on page 9-12.
5. Set up a licensed SQLCI2L program from a copy of the SQLCI2 program as
described in Appendix A, Licensed SQLCI2 Process:
33> LOGON SUPER.SUPER, password
34> FUP DUP $SYSTEM.SYSTEM.SQLCI2, $SYSTEM.SYSTEM.SQLCI2L
35> FUP SECURE SQLCI2L, "NN--"
36> SQLCOMP /IN SQLCI2L/ CATALOG $SYSTEM.SQL
37> FUP LICENSE SQLCI2L
-- --------------------------------------------------------------
-- BEGIN OBEY COMMAND FILE COMMAND SEQUENCE TO QUERY THE CATALOGS
-- TABLE AND GENERATE A REPORT IN INSERT-STATEMENT FORMAT
-- --------------------------------------------------------------
OUT_REPORT obey-insert-file CLEAR;
RESET LAYOUT *;
SET LAYOUT PAGE_LENGTH ALL;
RESET SESSION *;
SET SESSION LIST_COUNT 0;
RESET STYLE *;
SET STYLE HEADINGS OFF;
SELECT CATALOGNAME,
SUBSYSTEMNAME,
VERSION,
VERSIONUPGRADETIME,
CATALOGCLASS
FROM $catalogs-vol.SQL.CATALOGS
WHERE CATALOGCLASS <> "S"
;
DETAIL "INSERT INTO $new-catalogs-vol.SQL.CATALOGS", SKIP,
" VALUES (""", CATALOGNAME, """,", SKIP,
" """, SUBSYSTEMNAME, """,", SKIP,
" """, VERSION, """,", SKIP,
" ", VERSIONUPGRADETIME, " ,", SKIP,
" """, CATALOGCLASS, """" , SKIP,
" )", SKIP,
";", SKIP
;
LIST ALL;
-- in which obey-insert-file is any EDIT file;
-- catalogs-vol is the volume on which the current CATALOGS table
-- resides;
-- new-catalogs-vol is the volume on which the new CATALOGS table
is to
-- reside.
OUT_REPORT; -- Closes report file
RESET LAYOUT *; RESET STYLE *; -- Resets report defaults
RESET SESSION *; SET SESSION LIST_COUNT ALL;
-- --------------------------------------------------------
-- END REPORT PRODUCING COMMAND SERIES --------------------
-- --------------------------------------------------------