Manualshelf

NonStop NS-Series Database Migration Guide

ManualsBrandsHP ManualsServerHP Integrity NonStop Release and Migration
41424344454647484950
Migrating an SQL/MP or SQL/MX Database
HP Integrity NonStop NS-Series Database Migration Guide—540469-001
2-20
Steps for Moving an SQL/MX Database Using MXCI
DUP
7. Verify the status of the database by using the VERIFY utility or by using catalog
queries.
8. On the target node, create DEFINE names that point to the new locations of
SQL/MP tables and views.
9. On the target node, SQL compile the programs that were duplicated. For
information on compiling SQL programs, see Section 4, Migrating SQL/MP,
SQL/MX, and Enscribe Applications.
10. Make new TMF online dumps of all restored catalogs and audited objects.
Steps for Moving an SQL/MX Database Using MXCI DUP
1. Determine the names of the SQL catalogs involved in the move by querying the
CATSYS table in the system schema.
2. Determine the names of the SQL tables involved in the move by querying the
metadata of each schema. The OBJECTS table in
DEFINITION_SCHEMA_VERSION of each catalog stores information about
objects in all the schemas of the catalog.
3. If you need a consistent copy of the database, make sure that SQL/MX objects are
not in use, and stop all applications that access the database.
4. Use the REGISTER CATALOG command to register SQL/MX catalogs from the
NonStop S-series system on the Integrity NonStop NS-series system.
5. Using the table names identified in Step 2, use the MXCI DUP command to
duplicate the SQL/MX database from the source node to the target node.
6. On the target node, create DEFINE names that point to the new locations of
SQL/MX tables and views.
7. On the target node, SQL compile the programs that were duplicated. For
information on compiling SQL programs, see Section 4, Migrating SQL/MP,
SQL/MX, and Enscribe Applications.
8. Make new TMF online dumps of all restored catalogs and audited objects.
Additional Sources of Information
•
For detailed information about using SQLCI DUP to migrate a database, see the
SQL/MP Installation and Management Guide.
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 MXCI DUP. For assistance in migrating your database, consult HP
migration services. For information about these services, see Using HP Migration Services on
page 1-1.