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

Upgrading to SQL/MX Release 3.1
HP NonStop SQL/MX Release 3.1 Database and Application Migration Guide—663853-001
4-8
Upgrading the database and using new features on
existing and new databases

Execute the user modules and SQL queries compiled in SQL/MX Release 3.0
without any change.

Use the RCBs generated on SQL/MX Release 3.0 without any change.

Omit running the mxtool fixrcb. command.
Upgrading the database and using new
features on existing and new databases
After upgrading to SQL/MX Release 3.1 using the relevant upgrade sequence, you can
use the SQL/MX Release 3.1 features on existing and new databases. The scenarios
in this section describe how you can use the new features.

Scenario 1 - New features offered in SQL/MX Release 3.1 on existing database
and applications: To use new features offered in SQL/MX Release 3.1 on any
existing database and applications, you must upgrade all the metadata.

Scenario 2 - New features offered in SQL/MX Release 3.1 on new databases and
applications: After upgrading the system, newly created databases and
applications can use all the SQL/MX Release 3.1 features. Additionally, the newly
Note. An automatic recompilation of a SQL query with plan version 3000 will result in a query
with plan version 3100.
Figure 4-3. Using new features of SQL/MX Release 3.1 on existing databases
App1
cat1
sch1
R2.x
V1200
R3.1
R3.0
V3000
OR
App1
cat1
sch1
V3100
R3.1
Metadata
UPGRADE