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
172
Installing ALLBASE/ SQL or IMAGE/SQL
This applies to ALLBASE/SQL only if you have created SQL data using an earlier release of ALLBASE/SQL.
If you are updating from an earlier release of ALLBASE/SQL, you must perform the ALLBASE/SQL
migration to migrate your DBEnvironments to the G.3 format. The method used depends upon the version of
ALLBASE/SQL you are currently running. The version update options are:
Updating from any version of G
Updating from F.0
Updating from versions prior to E.1
CAUTION Execute SQLINSTL or SQLMigrate to migrate to the current version of ALLBASE/SQL.
Updating from Any G Version
If your old release of ALLBASE/SQL is G.0, G.1, G.2, or G.3, execute the SQLINSTL script to migrate to the
current version. ALLBASE/SQL has added new views and modified some existing views to support
TurboIMAGE indexes in IMAGE/SQL. The SQLINSTL script is provided in ALLBASE/SQL to make it easy for
a database administrator to migrate between versions of a release (such as G2.01 to G2.03) or minor releases
(such as G.2 to G.3). Using SQLINSTL ensures that you will have access to the most recent version of the
SYSTEM and CATALOG views, and it also uses VALIDATE FORCE statements to revalidate all stored sections for
the current version of ALLBASE/SQL.
If SQLINSTL is not executed on a DBEnvironment after installing a new version of ALLBASE/SQL, stored
sections may not be properly revalidated causing run-time errors. Revalidating stored sections at run-time
during production hours can also cause concurrency problems due to exclusive locks placed on the system
catalog. You must execute SQLINSTL whenever a new version of ALLBASE/SQL is installed unless you need to
use SQLMigrate. SQLINSTL does not need to be executed if SQLMigrate is being executed to migrate between
major releases.
Run the SQLINSTL script as follows:
:RUN ISQL.PUB.SYS
isql=> START SQLINSTL.PUB.SYS (MYDBE);
isql=> EXIT;
Please read the SQLINSTL file on your system for more information.
Customers who are using ARCHIVE MODE logging must make a backup of the DBEnvironment after using
SQLINSTL. This backup must be used if rollforward recovery is to be performed at some point in the future.
Customers installing G.3 cannot apply rollforward recovery to a backup created using the G.2 version (or
earlier) of ALLBASE/SQL.
Updating from Version E.1 or F.0
If your old release of ALLBASE/SQL is E.1 or F.0, use SQLMigrate to migrate to version G.3. Backup the
DBEnvironment prior to running SQLMigrate. The steps listed below also appear in the ALLBASE/SQL
Database Administration Guide.
Use the following procedure to convert a DBEnvironment from either an E.1 or F.0 format to the G.3 format: