Procedure documentationInitializing Databases Locate this document in the navigation structure

 

When you initialize a database, you delete all data (including the application data and database catalog) and all log entries from the volumes. The configuration of the database (database parameters, volume definitions, and so on) is retained, however.

Initializing a database is required in special recovery situations, for example.

Prerequisites

  • You are logged on to the database as database system administrator or as a DBM operator with server authorization for accessing utility sessions.

    More information: Glossary, Server Permission

  • For a database on the local computer, you require administration authorizations for the computer as an operating system user.

    For a database on a remote computer, you must be logged on to the remote computer as an operating system user with the following authorizations: administration authorizations and on Microsoft Windows additionally the Log on as batch job authorization. For more information, see your operating system documentation.

  • The database is in the OFFLINE operational state.

Procedure

  1. Select the database in the explorer tree.

  2. In the context menu of the database, choose   Administration Tasks   Initialize Database...  .

  3. Select Initialize the database.

  4. Select your database parameter options.

    Depending on your selection, choose a database or medium in the next step.

  5. Optional: Adjust individual database parameter values.

  6. Optional:

    1. Add, change, or delete data volumes.

      To add a new data volume, in the context menu of the Data Volumes screen area, choose New... and specify the properties of the new data volume.

      To change the properties of a data volume, choose Edit...in the context menu of the data volume and change the properties of the data volume.

      To delete a data volume, choose Delete in the context menu of the data volume.

    2. Add, change, or delete log volumes.

      To add a new log volume, in the context menu of the Log Volumes screen area, choose New... and specify the properties of the new log volume.

      To change the properties of a log volume, choose Edit...in the context menu of the log volume and change the properties of the log volume.

      To delete a log volume, choose Delete in the context menu of the data volume.

  7. Choose the recovery mode:

    • Create and start database

      Enter a new password for the database system administrator.

      All data and log entries in the database are deleted and the database is restarted.

      Afterwards, you can continue to work normally with the database.

    • Create database for recovery

      All data and log entries in the database are deleted and the database is transferred to the ADMIN operational state.

      Afterwards, you can only use this database for a recovery. During the recovery, the user information for the database system administrator is imported from the data data backup.

  8. To start the initialization, choose Initialize.

More Information

Restoring Databases