DBOPENfunctionality opens all available databanks in a system.
As each databank is opened, the integrity is checked and any transactions that were interrupted by the abnormal close are completed. (The integrity check is always performed when opening a databank that has not been closed normally.)
The checks performed when an abnormally closed databank is opened may take some time, particularly if the databank is large. Running
DBOPENmeans that the checks are performed at a time determined by the system administrator, rather than a time determined by application programs. As a result, users will always have fast access to all databanks.
The databanks are opened in a randomly determined order. Running several
DBOPENsessions in parallel may speed up the checking process for the database as a whole.
Any user who has
SELECTaccess to the data dictionary table
DBOPENexample shows the output from running dbopen after the system was shut down improperly:dbopen -s -usysadm -p****** MIMER Databank Open Utility Version 11.0.0A 2016-09-15 14:19:12.22 <Information> MIMER/DB kernel error -16211 in function DKVED0 Databank SYSDB not properly closed, dbcheck initiated 2016-09-15 14:19:22.67 <Information> MIMER/DB kernel error -16211 in function DKVED0 Databank TRANSDB not properly closed, dbcheck initiated 2016-09-15 14:19:22.71 <Information> MIMER/DB kernel error -16211 in function DKVED0 Databank LOGDB not properly closed, dbcheck initiated Opening databank APPDB1 All user databanks opened without errors
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40