SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Migrating an SQL/MP Database to NonStop SQL/MX
Release 2.1 or Release 2.0
HP NonStop SQL/MX Installation and Management Guide—523723-004
14-3
Planning to Migrate Applications
Planning to Migrate Applications
Planning activities for migrating applications depend on your environment and the
types of applications you are currently using. Before attempting to migrate data, review
these references.
Planning for Capacity and Performance
Before migrating your database, check that you have adequate disk space. Even with
adequate disk space, disk contention can be a problem if multiple databases share the
same disk.
Planning for Installation
It is important that database administrators and application developers fully understand
the new features provided in Release 2.1 and Release 2.0 and make effective use of
these features. You must also understand how to use the new features successfully
with earlier persistent entities. For example, earlier programs and query plans should
continue to work in the new environment, within the limits of interoperability.
To ensure effective use of the features of NonStop SQL/MX, follow this two-phase
strategy for installing Release 2.1 or Release 2.0 on system nodes:
1. Install the SQL/MX software on the relevant production nodes. For installation
procedures, see Section 3, Installing NonStop SQL/MX.
2. After you have successfully installed the software on all relevant nodes and it is
known to work satisfactorily, begin using the new features of NonStop SQL/MX on
these nodes. Features include:
°
Support for queries to SQL/MP tables using C and COBOL preprocessors that
generate only one executable file
°
IEEE floating-point support
°
The ability to create SQL/MX tables and use new features supported by the
new tables
For more information about See
Migrating SQL/MP applications or
Release 1.8 applications to Release
2.1 or Release 2.0
Section 11, Managing Database Applications
Revising SQL/MP statements to
SQL/MX statements and other
SQL/MP and SQL/MX considerations
SQL/MX Comparison Guide for SQL/MP Users
Compiling C and COBOL programs
for Release 2.1 or Release 2.0
SQL/MX Programming Manual for C and COBOL
Compiling Java programs for Release
2.1 or Release 2.0
SQL/MX Programming Manual for Java