MX Database and Application Migration Guide

Falling Back to NonStop SQL/MP

HP NonStop SQL/MP to NonStop SQL/MX Database and Application Migration Guide—666211-001

6-3

Steps for Falling Back to NonStop SQL/MP

4. To uninstall NonStop SQL/MX and reclaim more space on your system:

a. Remove SQL/MX user modules and DDL files containing SHOWDDL output:

cd /usr/tandem/sqlmx/USERMODULES

rm *

cd /usr/tandem/sqlmx/ddl

rm *

b. Remove the SQL/MX anchor file.

The

InstallSqlmx installation script creates an anchor file that contains the

locations of system metadata tables. This ASCII text file resides in Guardian

space in $SYSTEM.ZSQLMX.MXANCHOR. To remove this file:

a. Log on using the super ID (user ID 255,255).

b. At a TACL prompt, enter:

PURGE $SYSTEM.ZSQLMX.MXANCHOR

These manuals provide useful information:



The G06.nn or H06.nn Software Installation and Upgrade Guide provides

instructions for falling back to a previous RVU.



The SQL/MP Installation and Management Guide provides instructions for

installing, configuring, and maintaining NonStop SQL/MP.

Note. This example uses the system default locations for these files.