HP e3000 MPE/iX Release 7.0 System Software Maintenance Manual (30216-90317)

188 AppendixA
Manually Installed Products
Installing ALLBASE/ SQL or IMAGE/SQL
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:
SQLMIGRATE=> EXIT;
8. If the START DBE NEWLOG (issued by SQLMigrate) should fail for any reason, you must
run ISQL and issue the START DBE NEWLOG command from ISQL.
Run ISQL and issue a START DBE NEWLOG command as follows:
:RUN ISQL.PUB.SYS
isql=> START DBE ' dbenvironmentname ' NEWLOG
[DUAL LOG] LOG DBEFILE dbelog1id [AND dbel2id ]
WITH PAGES = dbelogsize , NAME = ' systemfilename1 '
[AND ' systemfilename2 '];
This creates a new log file under the current SQL version. If you are using ARCHIVE
MODE logging, issue the following commands:
isql=> BEGIN ARCHIVE;
isql=> COMMIT ARCHIVE;
Exit ISQL:
isql=> EXIT;
9. Run SQLUTIL and issue a SHOWDBE command to check the parameters of the new
version of the DBEnvironment. To use archive mode logging, run SQLUTIL and use the
STOREONLINE command. Issue the SHOWLOG command to verify that the ARCHIVE MODE
is set properly.
10.Exit SQLUTIL.
isql=> EXIT
DBEnvironment is now ready for access.
Updating from Versions Prior to E.1
If your old release of ALLBASE/SQL is earlier than E.1, you must perform two updates:
1. Update to ALLBASE/SQL, release E.1 or F.0