HP 3000 Manuals HP 3000 Manuals
Migrating a TurboIMAGE/V Database to MPE/iX
Migration of a database is a simple process and should take relatively
little effort in most cases. The process consists of performing a
DBSTORE/DBRESTOR of each database you need to move from an MPE V/E-based
system to an MPE/iX-based system. The most important step to remember
prior to migration is identifying the databases which have Intrinsic
Level Recovery (ILR) enabled. ILR should be disabled for a successful
migration. Please read the following steps completely before you try to
migrate a TurboIMAGE database.
Using DBSTORE/DBRESTOR is a simple way to move single databases between
systems where identical accounting structures exist. However, if you
need to move more than one database (or application program), it may be
more appropriate to migrate the entire operating system directory and all
the associated databases. The procedure for migrating a directory and a
number of databases is described in the next section.
The following steps summarize the process of migrating a single database
from an MPE V/E-based system to an MPE/iX-based system. Following the
list is an explanation and example of how to perform each of the steps.
1. Disable all flags (ILR, ROLLBACK, etc.) for the database (if in
use). This is important to do since a database with ILR enabled
which is moved from an MPE V/E-based to an MPE/iX-based system
cannot be opened. Please refer to the TurboIMAGE/V Reference
Manual (32215-90050) for more information on the ILR files.
2. Perform a DBSTORE or STORE of the database you want to move. An
example of how to use DBSTORE follows this list. DBSTORE and its
counterpart DBRESTOR should be in the PUB.SYS group and account.
Use of the :STORE command is explained in the next section.
3. Mount the DBSTORE tape on the tape drive connected to the
MPE/iX-based system and perform a DBRESTOR or RESTORE. An example
of using DBRESTOR follows. An example of using the :RESTORE
command is given in the next section.
At this point, the basic migration is finished and the database can now
be accessed. ILR does not need to be enabled to ensure database
integrity. The use of ILR on MPE/iX is discussed in the next section.
The following examples show how to disable ILR and to perform a STORE and
RESTORE of a TurboIMAGE database. It is recommended that ILR be disabled
before migrating the database.
Example of Disabling ILR
This example shows how to disable ILR:
:RUN DBUTIL.PUB.SYS
>>SHOW ORDERS FOR FLAGS
specify the database
>>DISABLE ORDERS FOR ILR
ILR DISABLED
>>EXIT
:
Example of Using DBSTORE (MPE V/E)
The following example shows how the ORDERS database was stored to tape on
an MPE V/E-based system with the DBSTORE program. DBSTORE was run from
the system console. The example shows both the prompts to the DBSTORE
command and the replies to the tape request.
Comments to the example are shown to the right of the input and are
bracketed by << >> symbols.
_______________________________________________________________________________________
| |
| |
| :RUN DBSTORE.PUB.SYS <<run command>> |
| |
| HP32215C.00.24 TurboIMAGE/3000: DBSTORE (C) COPYRIGHT HEWLETT-PACKARD CO. 1978 |
| |
| WHICH DATA BASE? ORDERS <<database name>> |
| |
| STORE/RESTORE, VERSION 2 (C) 1981 HEWLETT-PACKARD CO. |
| WED, AUG 5, 1987, 9:45 AM |
| |
| ?9:45/#S363/85/LDEV# FOR "DBSTORE" ON TAPE (NUM)? <<system prompt>> |
| =REPLY 85,7 <<console reply>> |
| 9:45/#S363/85/Vol (unlabeled) mounted on LDEV# 7 <<system reply>> |
| |
| FILES STORED: 7 <<# of files>> |
| |
| DATA BASE STORED <<confirmation>> |
| |
_______________________________________________________________________________________
Example of Using DBRESTOR (MPE/iX)
The following example shows how the ORDERS database was restored on an
MPE/iX based system.
______________________________________________________________________________________
| |
| |
| :RUN DBRESTOR.PUB.SYS <<run command>> |
| |
| HP30391C.00.00 TurboIMAGE/iX: DBRESTOR (C) COPYRIGHT HEWLETT-PACKARD CO. 1987 |
| |
| WHICH DATA BASE? ORDERS <<database name>> |
| |
| STORE/RESTORE, VERSION 2 (C) 1981 HEWLETT-PACKARD CO. |
| WED, AUB 5, 1987, 10:07 AM |
| |
| ?10:07/#S363/70/LDEV# FOR "DBRESTOR" ON TAPE (NUM)? <<system prompt>> |
| REPLY 70,7 <<console reply>> |
| |
| WILL RESTORE 1 DATABASES; NUMBER OF FILES ON TAPE = 7 <<# of files>> |
| |
| FILES RESTORED: 7 <<confirmation>> |
| |
______________________________________________________________________________________
At this point the database ORDERS has been successfully migrated to an
MPE/iX operating system. The database is now ready for access through
either the QUERY facility running in CM or through application programs.
ILR does not have to be enabled to ensure the logical integrity of the
database under MPE/iX. Please refer to the discussion of ILR and
transaction management in the next section.