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
174
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
2. Perform the ALLBASE/SQL migration update to release G.3 from E.1 or F.0.
Additional ALLBASE/SQL References
For additional information, please refer to the following ALLBASE/SQL reference materials.
• Up and Running with ALLBASE/SQL
• ALLBASE/SQL Reference Manual
• ISQL Reference Manual for ALLBASE/SQL and IMAGE/SQL
• ALLBASE/SQL Database Administration Guide
• ALLBASE/SQL Message Manual
• ALLBASE/SQL Advanced Application Programming Guide
• ALLBASE/NET Users Guide
• ALLBASE/SQL Performance and Monitoring Guidelines
• ODBCLINK/SE Reference Manual