SQL/MP Installation and Management Guide

Moving a Database

HP NonStop SQL/MP Installation and Management Guide—523353-004

9-25

Steps for Moving a Database

To move a database, follow these steps, which are demonstrated in Example 9-1 on

page 9-26:

1. Determine the name of the SQL catalogs involved in this move by querying the

CATALOGS table.

2. Determine the names of the SQL objects involved in this move by querying the

catalogs determined in Step 1.

3. Determine the dependencies with the DISPLAY USE OF command or with catalog

queries. It is important that you consider the interdependencies of the database for

the move.

4. If you need a consistent copy of the database, you should make sure the SQL

objects are not in use.

5. Perform the DUP or BACKUP/RESTORE command.

6. Verify the status of the database with the VERIFY utility or with catalog queries.

7. SQL compile the programs (by using SQLCOMP for SQL programs that run in the

Guardian environment or c89 for SQL programs that run in the OSS environment).

8. Make new TMF online dumps of all restored catalogs and audited objects.

Example of Moving a Database

The sample database released with the software is the database used in the example

of moving a database shown in Example 9-1 on page 9-26. This example shows

moving the database from volume $DATA to $DATA1 by using the DUP utility. The

example also shows the necessary steps and information required for moving a

database. In the example, descriptions of the steps for moving the database appear in

boldface text.