SQL/MX 2.x Database and Application Migration Guide (G06.23+, H06.04+, J06.03+)

Falling Back to NonStop SQL/MP
HP NonStop SQL/MX Database and Application Migration Guide—540435-005
12-3
Steps for Falling Back to NonStop SQL/MP
e. Use the DROP SQL command to drop the SQL/MX Release 2.x system
catalog. For complete command syntax and descriptions, see the
SQL/MX
Reference Manual.
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.