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

Falling Back to SQL/MX Release 1.8

HP NonStop SQL/MX Database and Application Migration Guide—540435-005

8-6

Install Compatible Versions of Independent Products

Independent products required by SQL/MX Release 1.8 are not installed when you

install or reload a previous RVU. To ensure correct installation, follow the installation

instructions of each independent product.

Start TMF

When you have loaded a previous RVU, start TMF using your site’s established

procedures.

Install SQL/MX Release 1.8

Follow the instructions in the SQL/MX Installation and Management Guide for SQL/MX

Release 1.8. You can find this manual in the G06.18 through G06.22 RVU publication

collections in the HP NonStop Technical Library.

Drop Remaining SQL/MX 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. From TACL, start the SQL/MP GOAWAY utility and use the GOAWAY command to

delete the SQL/MX files. For example, to delete the table mytable, enter:

2>GOAWAY mytable

To delete the shadow text label indexb, enter:

3>GOAWAY indexb:S

For more information about the GOAWAY command, see the SQL/MP Reference

Manual.

3. Rebuild the disk free-space table by using the SCF CONTROL DISK $

volume,

REBUILDDFS command. For more information about CONTROL DISK, see the

SCF Reference Manual for the Storage Subsystem.

Note. You must install fallback SPRs before falling back to SQL/MX Release 1.8.

Otherwise, the SQL/MP GOAWAY utility will not delete SQL/MX files. For more

information, see Planning for Fallback

on page 5-2.