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

Contents

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

3. Version Management and Interoperability

Working with v3000 and v1200 objects in SQL/MX Release 3.0 2-7

Conversions from numeric to char or varchar 2-7

Using the read-only transaction access mode 2-10

Recommendations for Migrating to SQL/MX Release 3.x 2-13

3. Version Management and Interoperability

NonStop SQL/MX Releases 3-1

SQL/MX Releases on Systems Running H-Series RVUs and J-Series RVUs 3-1

Naming Scheme for SQL/MX Releases 3-3

Product Version and SPR Identifiers 3-5

Availability of SQL/MX Releases 3-5

Delivery of SQL/MX Releases 3-6

RVUs and Supported SQL/MX Releases 3-6

Interoperability of NonStop SQL/MX Releases 3-7

Versions of SQL/MX Software Components 3-7

Version Identification of SQL/MX Software Components 3-7

SQL/MX System Software Version (MXV) 3-8

SQL/MX Database Object Versions 3-8

SQL/MX Query Plan and Module Versions 3-10

Interoperability Across Schema Versions 3-11

3-11

4. Upgrading to SQL/MX Release 3.0

Planning for Fallback 4-1

Installing SQL/MX Release 3.0 4-1

Preinstallation 4-1

Installing SQL/MX 3.0

4-2

Accessing the Database

4-2

Migrating the Database After System Upgrade 4-3

Migrating Applications after System Upgrade

4-3

Implementing the New Functionality 4-4

5. Falling Back to SQL/MX Release 2.x

Fallback sequence 5-1

Fallback Considerations

5-4

Preinstallation

5-5

Migrating the Database for System Fallback 5-5

Stopping TMF

5-6

Installing SQL/MX Release 2.3.4

5-6

Accessing the Database 5-6