www.mimer.com/developer

Removing a Mimer SQL Database

---

To remove a database, perform the following steps:

1. Check that no one is using the database.
2. Check that no database server is started against the database you are going to remove.
3. Create a list of all databank files by doing the following:

 $ bsql -s database
 Username: SYSADM
 Password: xxxxxx
 SQL> SELECT DATABANK_FILENAME FROM SYSTEM.DATABANKS;
 SQL> EXIT;
 

4. Using the list generated in the previous step, locate and delete all the physical databank files. If the file name does not contain a directory specification, the directory will be the home directory of the database.
5. Delete any directories that have been specifically created to hold databank files for the database.
6. Delete the database entry in:

 SYS$SPECIFIC:[SYSMGR]SQLHOSTS.DAT
 

Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se