MX Database and Application Migration Guide

Contents

HP NonStop SQL/MP to NonStop SQL/MX Database and Application Migration Guide—666211-001

3. Preparing to Migrate From NonStop SQL/MP to

NonStop SQL/MX

Product Version and SPR Identifiers 2-5

Availability of SQL/MX Releases 2-5

Delivery of SQL/MX Releases 2-6

RVUs and Supported SQL/MX Releases 2-6

Interoperability of NonStop SQL/MX Releases 2-7

Versions of SQL/MX Software Components 2-7

Version Identification of SQL/MX Software Components 2-7

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

SQL/MX Database Object Versions 2-8

SQL/MX Query Plan and Module Versions

2-10

Interoperability Across Schema Versions

2-11

3. Preparing to Migrate From NonStop SQL/MP to NonStop

SQL/MX

Using NonStop SQL/MX and NonStop SQL/MP Together 3-1

Meeting System Hardware Requirements 3-1

Migrating From S-Series Systems to NS-Series Systems 3-2

Meeting Operating System Requirements 3-2

Planning for Performance and Capacity 3-2

Planning for Fallback 3-3

Planning New Feature Implementation 3-3

Keeping SQL/MP Applications, Database Objects, and Metadata 3-3

Installing SQL/MX Release 3.0 3-3

Installing Corequisite Independent Products 3-4

Preparing to Migrate SQL/MP Applications

3-4

Preparing to Migrate SQL/MP Database Objects 3-4

4. Converting SQL/MP Applications to SQL/MX Applications

Converting SQL/MP Applications to SQL/MX Applications 4-2

ANSI Compliance and Portability

4-2

New Functionality in NonStop SQL/MX 4-2

Ability to Query SQL/MX Database Objects 4-4

Redesigned Optimizer and Executor 4-4

Parallel Operations for Scalable High Performance 4-5

Reasons for Keeping SQL/MP Applications 4-5

Types of SQL/MP Applications to Convert

4-6

Converting Embedded SQL/MP Applications to NonStop SQL/MX

4-6

Converting ODBC Client Applications to NonStop SQL/MX 4-7