SQL/MP Installation and Management Guide

Removing SQL/MP From a Node
HP NonStop SQL/MP Installation and Management Guide—523353-004
B-2
Using the CLEANUP Utility to Remove SQL Objects
3. For SQL tables containing data you need to preserve for use after removing SQL,
create empty Enscribe files. Then, use the SQLCI COPY or LOAD utility to copy
the tables into those Enscribe files.
4. Use the CLEANUP utility to purge the SQL objects and the catalogs in which they
are described. You must ensure that you do not prematurely apply CLEANUP to
the system catalog in which the $SYSTEM.SYSTEM.SQLCI2 program is
registered. Therefore, you should either purge each disk volume one at a time or
purge all objects except those in the system catalog.
This CLEANUP command purges all objects except those residing in the system
catalog:
24> SQLCI
>> CLEANUP ! (*.*.* EXCLUDE ($vol.syscat.*,
+> $SYSTEM.SYSTEM.SQLCI2)), CATALOGS;
In this CLEANUP command, $vol.syscat is the name of the system catalog.
The CATALOGS option purges the catalog tables from the designated disk volume.
5. Purge all the SQL objects from the system catalog except the
$SYSTEM.SYSTEM.SQLCI2 program.
To perform this operation, enter this command:
>> CLEANUP $vol.syscat.* ! EXCLUDE $SYSTEM.SYSTEM.SQLCI2;
6. Use the DSAP to verify that the only SQL objects existing on your node are the
system catalog and $SYSTEM.SYSTEM.SQLCI2. Although you follow the
preceding steps precisely, DSAP might identify certain objects of a special type, or
shadow labels, that still reside on your disks. These shadow labels are created by
the disk process.
To generate a DSAP report of all SQL objects on each disk, enter command at the
command interpreter prompt:
25> DSAP volume, SQL
In the DSAP command, volume is the name of a volume on which SQL objects
existed.
In an OBEY command file, enter the DSAP command once for every volume on
which SQL/MP objects exist, and then run the commands from the OBEY
command file.
DSAP lists any SQL catalogs, objects, or programs that you did not remove in the
preceding steps. If no SQL objects other than the system catalog and
$SYSTEM.SYSTEM.SQLCI2 remain on the node, proceed to Step 8 on page B-3.
Caution. In the CLEANUP command, do not use the CATALOGS option; you cannot yet purge
the system catalog.