NonStop NS-Series Database Migration Guide

Migrating an SQL/MP or SQL/MX Database
HP Integrity NonStop NS-Series Database Migration Guide—540469-001
2-12
Steps for Moving an SQL/MP Database by Using
ALTER TABLE MOVE and ALTER INDEX MOVE
Steps for Moving an SQL/MP Database by Using ALTER TABLE
MOVE and ALTER INDEX MOVE Statements
1. On the source system, verify that the SQL/MP catalogs have been upgraded to
catalog version 350, which is supported on TNS/E systems.
Table 2-3. Advantages and Disadvantages of Using ALTER TABLE MOVE and
ALTER INDEX MOVE Statements
Advantages Disadvantages
•
You can keep SQL/MP database
objects online during most of the move.
•
You can increase the size of individual
partitions and split partitions to take
advantage of the disk storage
capabilities of the Integrity NonStop
NS-series system.
•
You must write individual ALTER
TABLE MOVE statements for each
table partition and write ALTER INDEX
MOVE statements for each index
partition. This task can be time-
consuming and problematic if there are
many partitions in your database.
•
ALTER TABLE MOVE moves the
database objects to the new system
without keeping copies on the old
system. Therefore, reversing the
migration involves as much work as the
migration itself.
•
Some downtime occurs for SQL
applications that operate on the
database. After the database objects
are moved, applications lose access to
the database objects, and the query
execution plans undergo similarity
checks and possible automatic
recompilation.
•
During migration, the audit fixup stage
generates audit on the destination
system. If there are many changes to
the data compared to the size of the
partition, the audit will be large.
•
If the connection between the systems
is lost during migration, cleaning up
partially completed operations is difficult
and time-consuming.
Caution. Migrating a database from a NonStop S-series system to an Integrity NonStop
NS-series system is a complex endeavor. These steps provide a general overview of how to
migrate a database using ALTER TABLE MOVE and ALTER INDEX MOVE statements. For
assistance in migrating your database, consult HP migration services. For information about
these services, see Using HP Migration Services
on page 1-1.