Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site

http://developer.mimer.com


Re-creating TRANSDB, LOGDB and SQLDB


No Mimer SQL applications can be run if LOGDB, TRANSDB or SQLDB is missing. In this event, starting the UTIL program and logging in as SYSADM will give you an opportunity to re-create the missing databanks with the same file names as the lost databanks, or to alter the recorded filenames in the case where the physical files were moved.

The following example shows how to re-create LOGDB for a database where this system databank is missing:

                          M I M E R / U T I L
                         
                           Username: SYSADM
                           Password: 
 
 MIMER/DB fatal error -16142 in function CONNECT
          Cannot open databank LOGDB,
          file logdb8 not found
 
 -- Redefinition of system databank --
 
 -- Description of databank name and file --
 
 DATABANK FILENAME
 ===============================================================
 LOGDB    logdb8 
 Re-definition of LOGDB? [Y]: Y
 CREATE new file or ALTER filename for LOGDB? (C/A): C
 Size [1000]                 : 5000
 
 Databank LOGDB redefined
 

If a database has been operational for some time, a situation may arise where one or more of the system databanks LOGDB, TRANSDB or SQLDB has grown so large that it is desirable to delete the file and create a new empty databank.

But, since these databanks (at least TRANSDB and LOGDB) are so vital to the system consistency, we strongly recommend that these files are kept intact whenever possible.

A complete backup of the entire database should be made before any system databanks are recreated.

The following sections describe how to re-create each of the respective system databanks.

Creating a New LOGDB

To create a new LOGDB:
  1. Shut down the database server (if not already stopped).
  2. Run DBCHECK on SYSDB and all the user databank files to ensure that none are corrupted.
  3. Take a valid backup of the whole database.
  4. Archive a copy of the LOGDB databank file and delete the original file from disk.
  5. Start the database server.
  6. Start the UTIL program, logging in as SYSADM, and when prompted, select the CREATE option and specify a path name and a size for the new LOGDB databank file.

Creating a New TRANSDB

To create a new TRANSDB:
  1. Shut down the database server (if not already stopped).
  2. Ensure that all pending transactions have been flushed to the user-databank files on disk by successful execution of DBOPEN in single-user mode.
  3. Archive a copy of the TRANSDB databank file and delete the original file from disk.
  4. Start the database server.
  5. Start the UTIL program, logging in as SYSADM, and when prompted, select the CREATE option and specify a path name and size for the new TRANSDB databank file.

Creating a New SQLDB

To create a new SQLDB:
  1. Shut down the database server (if not already stopped).
  2. Delete SQLDB from disk.
  3. Start the database server.
  4. Start the UTIL program, logging in as SYSADM, and when prompted, select the CREATE option and specify a size for the new SQLDB databank file.


Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Documentation TOC PREV NEXT INDEX