SQL/MX 2.x Database and Application Migration Guide (G06.23+, H06.04+, J06.03+)

HP NonStop SQL/MX Database and Application Migration Guide—540435-005
9-1
9
Preparing to Migrate From NonStop
SQL/MP to NonStop SQL/MX
Before migrating from NonStop SQL/MP to NonStop SQL/MX, follow these planning
guidelines:
•
Using NonStop SQL/MX and NonStop SQL/MP Together on page 9-1
•
Meeting System Hardware Requirements on page 9-1
•
Meeting Operating System Requirements on page 9-2
•
Planning for Performance and Capacity on page 9-2
•
Planning for Fallback on page 9-3
•
Installing the Latest Supported Version of SQL/MX Release 2.x on page 9-4
•
Installing Corequisite Independent Products on page 9-4
•
Preparing to Migrate SQL/MP Applications on page 9-5
•
Preparing to Migrate SQL/MP Database Objects on page 9-5
Using NonStop SQL/MX and NonStop SQL/MP
Together
NonStop SQL/MX and NonStop SQL/MP can coexist on the same system. Therefore, if
you want to use NonStop SQL/MX, you are not required to convert your existing
SQL/MP applications and database objects to NonStop SQL/MX.
If you have NonStop SQL/MX installed on your system, you can create new SQL/MX
applications that access SQL/MP database objects. SQL/MX Release 2.x applications
can access SQL/MP database objects, SQL/MX database objects, or both. For more
information, see Migrating From NonStop SQL/MP to NonStop SQL/MX
on page 1-3.
Section 10, Converting SQL/MP Applications to SQL/MX Applications
, and Section 11,
Converting an SQL/MP Database to SQL/MX Tables, explain how to convert SQL/MP
applications and database objects, respectively, to NonStop SQL/MX. You can use the
information in those sections to help you develop and implement new SQL/MX
applications and database objects.
Meeting System Hardware Requirements
SQL/MX Release 2.x requires processors that support IEEE floating-point functions. All
NS-series systems have processors that support IEEE floating-point functions. All
processors in an S-series node on which SQL/MX Release 2.x is installed must be