Procedure documentationDeleting a Database Locate this document in the navigation structure

 

To delete a database, you first transfer it to the OFFLINE operational state. If you want to keep the database files, you can specify this in the command for deleting the database.

Scenario

You want to delete the database DEMODB including all database files (system default value).

Prerequisites

You can find the prerequisites under Database Manager CLI, db_offline, db_drop

Procedure

  1. Call Database Manager CLI in session mode, log on as operator DBM with the password DBM, connect to the database DEMODB:

    >dbmcli –u DBM,DBM –d DEMODB

    dbmcli on DEMODB>

  2. Transfer the database to the OFFLINE operational state:

    dbmcli on DEMODB>db_offline

    OK

  3. Delete the database:

    dbmcli on DEMODB>db_drop

    OK

Result

You have deleted the database DEMODB.

You can confirm this by displaying the list of existing databases (see: Database Manager CLI, db_enum).