HP Integrity NonStop H-Series - Manual (Page 112)

Configuring DSM/SCM
DSM/SCM User’s Guide — 529846-014
5 - 27
Configuring a Backup Host System
6. Drop the host database manager program file PHIHDBMG:
>SQLCI DROP PROGRAM $DSMSCM.XPHIHDB.PHIHDBMG; EXIT;
7. Drop the host database catalog:
>SQLCI DROP CATALOG $DSMSCM.XPHIHDB; EXIT;
8. Check that the ADDTDEFS file reflects the proper system:
a. Check the system name in the file to see if it lists your backup host or
your old primary host. Check ADD DEFINE lines such as:
ADD DEFINE =PHITDB, SUBVOL \sysname.$DSMSCM.Xsystem
b. If the listed system name lists the old primary host instead of the
backup host, use EDITOR to update the file (it is case-sensitive):
> EDIT ADDTDEFS
C/old-system-name/new-system-name/A
9. Run the ADDTDEFS file:
>OBEY $DSMSCM.ZDSMSCM.ADDTDEFS
10. Run the file TDBREL2 to drop most target database tables:
>SQLCI OBEY TDBREL2; EXIT;
11. Drop the program file PHITDBMG (sysname is the target system name):
>SQLCI DROP PROGRAM $DSMSCM.Xsysname.PHITDBMG; EXIT;
12. Drop the target database catalog (sysname is the target system name):
>SQLCI DROP CATALOG $DSMSCM.Xsysname; EXIT;
13. Check that no more databases remain on the backup host system:
>VOLUME $DSMSCM.SQL

>SQLCI

>> SELECT * FROM CATALOGS;

>> EXIT;
Any remaining databases and the system catalog (usually SQL) are
displayed.
b. If the backup host has non-DSM/SCM databases:
1. To delete existing databases and catalogs, see the SQL/MP Reference
Manual.
2. Delete the system catalog.
c. Drop the system catalog:
> SQLCI DROP SYSTEM CATALOG $DSMSCM.SQL; EXIT;