SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Falling Back From NonStop SQL/MX Release 2.1 or
Release 2.0
HP NonStop SQL/MX Installation and Management Guide—523723-004
A-6
Load a Previous RVU
The InstallSqlMx installation script creates an anchor file that contains the
locations of system metadata tables. This simple 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
Load a Previous RVU
Follow the instructions in the G06.nn Software Installation and Upgrade Guide to fall
back to a previous RVU.
Drop Remaining Release 2.1 or Release 2.0 Objects
After falling back, if you have to remove any residual SQL/MX objects:
1. Use the FUP INFO command to locate any SQL/MX files remaining on the system.
Because SQL/MX objects reside in subvolumes that begin with the letters ZSD,
you can use this command to find them:
1>FUP INFO $*.ZSD*.*
2. Use the DELETE command of the DIRCHECK disk utility to delete the files. For
example:
TACL2>$system.zutil.dircheck delete name $data08.zsdm819j.wdxhp600
System: \MOLE PID: (0, 72) 8-Apr-2004 18:06:57
*WARNING* SQL Catalog will not be updated when SQL labels are deleted.
*WARNING* Extents are lost when file/table labels are deleted.
Delete Command: 3 labels deleted.
Note these considerations for using DIRCHECK:
°
To use DIRCHECK, you must be the super ID (user ID 255,255).
°
The DIRCHECK DELETE command deletes any internal labels associated with
a specified file, which is why DIRCHECK indicates that multiple labels have
been deleted after you delete one file.
Caution. When you fall back from Release 2.1 or Release 2.0 to Release 1.8, the
InstallSqlmx script remains in the /usr/tandem/sqlmx/bin directory. InstallSqlmx
is not designed to run from the Release 1.8 environment. If you attempt to do so, error
messages are generated, and the SQL/MX installation aborts.
Delete InstallSqlmx when you fall back from Release 2.1 or Release 2.0 to Release 1.8.
From the Release 1.8 environment, enter this command from the OSS space:
rm /usr/tandem/sqlmx/bin/InstallSqlmx