MX 3.0 Database and Application Migration Guide (H06.22+, J06.11+)

HP NonStop SQL/MX 2.3.x to SQL/MX 3.0 Database and Application Migration Guide—666210-002

4-1

Upgrading to SQL/MX Release 3.0

This section addresses the following topics:



Planning for Fallback on page 4-1



Installing SQL/MX Release 3.0 on page 4-1



Implementing the New Functionality on page 4-4

Planning for Fallback

Before you install SQL/MX Release 3.0, plan for a fallback to a version of SQL/MX

Release 2.x. 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 version of SQL/MX Release 2.x, see Section 5, Falling Back to

SQL/MX Release 2.x.

Installing SQL/MX Release 3.0

To upgrade a system from SQL/MX Release 2.3.x to SQL/MX Release 3.0, perform the

following tasks:



Preinstallation



Installing SQL/MX 3.0



Accessing the Database



Migrating the Database After System Upgrade



Migrating Applications after System Upgrade

Preinstallation

Complete the following prerequisites:

1. Stop all applications that access the database.

2. Stop the HP NonStop Transaction Monitoring Facility (TMF) twice with no database

activity between the two stops:

TMF 1> STOP TMF

TMF 2> START TMF

Note. When using new features, if you encounter a problem that is specific to SQL/MX

Release 3.0, discontinue the use of those features instead of falling back from that database

environment.