Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


Functions


The DBOPEN functionality 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 DBOPEN means 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 DBOPEN sessions in parallel may speed up the checking process for the database as a whole.

Authorization

Any user who has SELECT access to the data dictionary table SYSTEM.DATABANKS can run DBOPEN.

Output Example

The following DBOPEN example shows the output from running dbopen after the system was shut down improperly:

 dbopen -s -usysadm -p******
 
 MIMER Databank Open Utility 
 Version 10.1.0A
 
 2011-09-15 14:19:12.22   <Information>
 MIMER/DB kernel error -16211 in function DKVED0
 Databank SYSDB not properly closed, dbcheck initiated
 
 2011-09-15 14:19:22.67   <Information>
 MIMER/DB kernel error -16211 in function DKVED0
 Databank TRANSDB not properly closed, dbcheck initiated
 
 2011-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
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX