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-11
Additional Sources of Information
MODIFY DICTIONARY CATALOG commands in the correct order to correctly
update the database.
•
Partitioned objects. Node numbers in the file labels of other partitions of tables
and indexes are not modified unless the other partitions are specified in the
MODIFY DICTIONARY LABEL command. The MODIFY DICTIONARY CATALOG
command does not modify information about partitions that are in other catalogs
unless the other catalogs are specified.
MODIFY DICTIONARY does not automatically correct information about all
partitions of a partitioned object. For a partitioned SQL/MP object, separately
specify each volume that contains a partition of the object.
Additional Sources of Information
•
For detailed information about using the SQLCI MODIFY and VERIFY commands,
see the SQL/MP Reference Manual.
•
For information about migrating a database that has audited objects, see the TMF
Operations and Recovery Guide.
Migration by Using ALTER TABLE MOVE and
ALTER INDEX MOVE Statements
Use the ALTER TABLE MOVE and ALTER INDEX MOVE statements to move a
simple SQL/MP database that has few partitions from a NonStop S-series system to an
Integrity NonStop NS-series system. By using the WITH SHARED ACCESS option of
an ALTER TABLE MOVE statement, you can keep SQL/MP database objects
accessible to applications during most of the database migration.
Advantages and Disadvantages
Before choosing this method of migration, consider the advantages and disadvantages
of using ALTER TABLE MOVE and ALTER INDEX MOVE statements as described in
Table 2-3
.