HP e3000 MPE/iX System Software Maintenance Manual (Release C.75.00) (30216-90344)

Appendix A
Manually Installed Products
Installing ALLBASE/ SQL or IMAGE/SQL
173
1. Prior to updating the operating system and ALLBASE/SQL software, do the following for each
DBEnvironment that will be migrated:
a. Run ISQL.PUB.SYS and issue a START DBE command. This ensures that the DBEnvironment is
logically consistent in the event that it has not been accessed since a system failure occurred.
b. Run SQLUTIL.PUB.SYS and issue the STORE command to backup each DBEnvironment.
Log files are not stored using this command. In addition, you should use the SHOWDBE command to
ensure that all parameters are OK.
2. Backup the ALLBASE/SQL software. This can be done as part of the system backup.
3. Update the operating system. The ALLBASE/SQL software is updated as part of the SUBSYS add-on
process.
4. Start SQLMigrate.
:RUN SQLMIG.PUB.SYS
5. For each DBEnvironment that you are migrating, check for potential errors by using the PREVIEW
command below:
SQLMIGRATE=> PREVIEW 'DBEnvironmentName' FORWARD;
The PREVIEW command is not a read-only command. Make sure that you have a backup of the
DBEnvironment prior to issuing the PREVIEW command.
During the PREVIEW check, you may receive messages indicating that there is insufficient disk space in
the system DBEFileSet. If this occurs, use the following commands to create a new DBEFile and add it to
the SYSTEM DBEFileSet:
SQLMIGRATE=> CREATE DBEFILE dbefileName WITH PAGES
= dbefilesize, NAME='systemfilename';
SQLMIGRATE=> ADD DBEFILE dbefilename TO DBEFILESET SYSTEM;
Note that the syntax of the above commands is the same as in ISQL.
Repeat this step until no errors are encountered and SQLMigrate returns the following message:
The proposed migration should be successful
6. Issue the MIGRATE command as follows:
SQLMIGRATE=> MIGRATE 'dbenvironmentname' FORWARD;
When the forward migration has successfully completed, SQLMigrate purges the old log files and
performs a START DBE NEWLOG to create a new log file using the parameters stored in the DBECON file.
The following is a sample listing.
START DBE NEWLOG BEGINNING (MON, JUL 19, 1995, 4:12 PM)
START DBE 'DBENAME' NEWLOG
BUFFER = (100,24),
TRANSACTION = 2,
MAXIMUM TIMEOUT = NONE,
DEFAULT TIMEOUT = MAXIMUM,
RUN BLOCK = 37
LOG DBEFILE LOG1 WITH PAGES = 250,
NAME = 'DBELOG1';
START DBE NEWLOG SUCCEEDED (MON, JUL 19, 1995, 4:13 PM)
7. Exit SQLMigrate: