SQL/MP Installation and Management Guide

HP NonStop SQL/MP Installation and Management Guide—523353-004

B-1

Removing SQL/MP From a Node

If you want to install a version of the operating system that does not support SQL/MP,

you must remove SQL/MP and all SQL objects from your system (node). A version of

the operating system that does not support SQL/MP does not recognize the SQL file

structure. You must remove all references to SQL objects before installing that version.

To remove OSS programs, use OSS utilities. For more information, see the Open

System Services Shell and Utilities Reference Manual.

Using the PUP FORMAT Command to Remove

SQL Objects

If you do not need to preserve any data from SQL files, the easiest way to remove

SQL/MP is by formatting all the disk volumes:

1. Back up any Enscribe files, EDIT files, and other files to tape by using the

DP2FORMAT of BACKUP.

2. Create a new SIT tape.

3. Cold load the new SIT tape by using the $SYSTEM format tape cold-load method

of installation. This operation formats $SYSTEM and restores the SIT to

$SYSTEM.

4. Complete the INSTALL steps.

5. Use PUP FORMAT and LABEL (D-series only) to format and label all the disk

volumes. Use SCF INITIALIZE DISK and ALTER DISK, LABEL (G-series only) to

format and label all the disk volumes.

6. Use RESTORE to restore the Enscribe files, EDIT files, and other files that were

backed up before the cold load.

Using the CLEANUP Utility to Remove SQL

Objects

If you need to retain the data in SQL/MP objects, or if you need to convert SQL tables

to Enscribe files, you must carefully follow these steps:

1. Check that the TMF subsystem is operational. Enable all volumes containing SQL

objects for TMF auditing.

2. Back up SQL objects that you want to save with the ARCHIVEFORMAT option of

BACKUP.