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-7
Steps for Moving an SQL/MP Database by
Physically Disconnecting and Reconnecting Disk
Steps for Moving an SQL/MP Database by Physically
Disconnecting and Reconnecting Disk Storage Devices Between
Systems With the Same Name
These steps are based on the assumption that the NonStop S-series system and the
Integrity NonStop NS-series system have the same node name and number and,
therefore, are on the same TCP/IP network but not on the same Expand network.
1. Stop your database applications and stop NonStop TMF on the old system. If the
new system already contains a NonStop TMF configuration, then stop TMF on the
new system also.
2. Disconnect the disk storage devices.
°
If the new system contains a TMF configuration: Disconnect only the disk
storage devices containing the database volumes. (This strategy allows you to
move only the database volumes on the old disk drives to the new system,
then start the audit trails on the new, faster disk drives on the new system. The
result is better performance for your audit trails due to the faster disk drives,
but a slower migration.)
°
If the new system does not contain a TMF configuration: Disconnect the disk
storage devices containing the database volumes, the TMF audit volumes, and
the TMF configuration. (This strategy requires you to move all your database
volumes, TMF audit volumes, and TMF configuration on the old disk drives to
the new system. The result is a faster migration but slower performance due to
the audit trails on the old disk drives.)
Table 2-2. Advantages and Disadvantages of Physically Disconnecting and
Reconnecting Disk Storage Devices
Advantages Disadvantages
•
In general, this method is faster
than using a DUP or
BACKUP/RESTORE method
because you do not need to copy
data.
•
This method is an offline operation; it
requires system downtime. The amount of
downtime required depends on the
complexity of reconnecting the disk storage
devices. The time required to update the
SQL/MP database depends on the size of
the database.
•
This method incurs greater risk than copy
methods because you have only one copy of
the database.
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 by physically disconnecting and reconnecting disk storage devices. For
assistance in migrating your database, consult HP migration services. For information about
these services, see Using HP Migration Services
on page 1-1.