HP e3000 MPE/iX Release 6.5 System Software Maintenance Manual (30216-90325)

192 AppendixA
Manually Installed Products
Installing ALLBASE/ SQL or IMAGE/SQL
Installing ALLBASE/ SQL or IMAGE/SQL
This applies to IMAGE/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 E.1 or 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.