SQL/MX 3.1 Database and Application Migration Guide (H06.23+, J06.12+)

HP NonStop SQL/MX Release 3.1 Database and Application Migration Guide—663853-001

4-1

Upgrading to SQL/MX Release 3.1

This section addresses the following topics:



Planning for fallback on page 4-1



Upgrading from SQL/MX Release 2.3.x to SQL/MX Release 3.1 on page 4-1



Upgrading from SQL/MX Release 3.0 to SQL/MX Release 3.1 on page 4-5



Upgrading the database and using new features on existing and new databases on

page 4-8



Implementing the new functionality on page 4-9

Planning for fallback

Before you install SQL/MX Release 3.1, plan for a fallback to an earlier version. To fall

back to versions earlier than SQL/MX Release 2.3.4, you must first fall back to

SQL/MX Release 2.3.4 and then to the required SQL/MX 2.x version.

To fall back to a previous version of SQL/MX, see Section 5, Falling Back from

SQL/MX Release 3.1.

Upgrading from SQL/MX Release 2.3.x to

SQL/MX Release 3.1

This section describes the sequence and the procedures to upgrade from SQL/MX

Release 2.3.x to SQL/MX Release 3.1.



Upgrade sequence on page 4-1



Preinstallation on page 4-3



Installing SQL/MX Release 3.1 on page 4-3



Accessing the database on page 4-3



Migrating the database after system upgrade on page 4-4



Migrating applications after system upgrade on page 4-4

Upgrade sequence

To upgrade from SQL/MX Release 2.3.x to SQL/MX Release 3.1, you must follow the

sequence shown in Figure 4-1

Note. When using new features, if you encounter an issue that is specific to SQL/MX Release

3.1, discontinue the use of those features instead of falling back from that version.