SQL/MP Installation and Management Guide

Removing SQL/MP From a Node
HP NonStop SQL/MP Installation and Management Guide—523353-004
B-3
Using the CLEANUP Utility to Remove SQL Objects
7. If any shadow labels remain on the node, however, you must remove them before
removing SQL. At the SQLCI prompt, enter:
>> CLEANUP *.*.*, SHADOWSONLY;
If any SQL objects other than shadow labels remain on the node, specify the name
of each object in a CLEANUP command.
Repeat Step 6 on page B-2 until DSAP does not list any SQL objects except the
system catalog and $SYSTEM.SYSTEM.SQLCI2.
8. Drop the system catalog. This operation also implicitly drops the
$SYSTEM.SYSTEM.SQLCI2 program. This command accomplishes this step:
26> SQLCI DROP SYSTEM CATALOG system-catalog;
In the DROP SYSTEM CATALOG command, system-catalog is the name of
the volume and subvolume that contain the system catalog. This command can be
entered from SQLCI, provided that SQLCI2 is not running. Alternatively, this
command can be entered at any time from TACL, as shown in the preceding
example. For more information, see the description of the command in the
SQL/MP Reference Manual.
9. If you have performed the preceding steps but SQL objects still exist on your node,
call your service provider for further help before you load the planned operating
system.
If no SQL objects exist, you have removed SQL/MP from the node successfully.
You can now load the operating system that does not support SQL/MP.
Note. If SQL objects, with the exception of the system catalog and the
$SYSTEM.SYSTEM.SQLCI2 program, cannot be removed by Steps 1 to 7, contact your
service provider.