Procedure documentationCreating Databases Locate this document in the navigation structure

Prerequisites

  • You are logged on as an operating system user to the computer on which you want to create the database.

  • Depending on your operating system and system configuration, you might have to be logged on as a special operating system user.

    More information: Database Administration, Special Operating System Users and User Groups

  • To create a database on a remote computer, the global listener and the X server (SAP MaxDB communication server) of the installation in which you want to create the new database must be running on the remote computer.

    More information: Global Listener and X Servers, Starting the Global Listener and/or Installation-Specific X Servers

  • To create a database on a remote computer that uses Microsoft Windows, you must have administration rights for the remote computer as well as the Log on as Batch Job authorization.

    More information: Operating System Documentation

Procedure

  1. In the context menu of Servers, choose   Administration Tasks   Create Database...  

  2. Select your installation mode:

    • Create a new database

      Simple mode (system default)

      All important database properties are pre-configured, but you can still adjust some of them during the creation of the database.

    • Create a new database in advanced mode

      Advanced mode

      You configure the database properties during the creation of the database.

Simple Mode (System Default)
  1. Enter the following data:

    Property

    Description

    Database Server

    Name or IP address of the computer on which you want to create the database

    To create the database on the local computer, leave the field blank or enter <Local>.

    Database Name

    More information: Database Administration, Conventions for Database Names

    Login Name

    Only necessary if you create the database on a remote computer

    Name of the operating system user on the remote computer

    Password

    Only necessary if you create the database on a remote computer

    Password of the operating system user on the remote computer

  2. Enter the following data:

    Property

    Description

    User Name

    Name of the database system administrator

    The system administrator is the user with the most extensive database authorizations.

    More information: Database Administration, Database System Administrator

    Password

    Password of the database system administrator

    More information: Database Administration, Conventions for User Names and Passwords

    Installation

    Version and path of the database software that you want to use to create the database

  3. Optional: Configure important database properties using the following database paramaters:

    Property

    Database Parameter

    Description

    Memory Cache Size

    CacheMemorySize

    Size of the working memory (RAM) used by the database system

    Note that this parameter only roughly determines the size of the working memory used by the database. There are database functions which also need a certain amount of working memory, but whose memory consumption is not configured with this parameter.

    Max. User Tasks

    MaxUserTasks

    Maximum number of user tasks (number of database users that can be concurrently logged on to the database)

    Max. SQL Locks

    MaxSQLLocks

    Maximum number of SQL locks

    Run Directory Path

    RunDirectoryPath

    Path of the database run directory

    More information: Database Administration, General Database Parameters

  4. The system saves the data and log entries of the database in the volumes.

    Optional: Change the configuration of the first data volume and the first log volume.

    Volumes: Properties

    Property

    Description

    Size

    Minimum size: 1000 pages or 8000 KB

    Device/File

    Device/path and file name

    Type

    Type of physical memory

    • FILE (F)

      A volume can be a part of a physical hard disk, a complete physical hard disk, or a storage system consisting of several storage units.

      Can be used on all operating systems

    • LINK (L)

      Can only be used on Unix and Linux

    • RAW (R)

      Raw device

      Can only be used on Unix and Linux

    More information: Concepts of the Database System, Volumes (Permanent Storage)

  5. Optional: Configure additional database properties.

    Property

    Description

    Load tutorial data

    More information: Concepts of the Database System, Demo Database

    Activate overwrite mode for the log area

    More information: Glossary, Overwrite Mode for the Log Area

    Automatic log backup:

    • Initial complete data backup

    • Log backup

    If automatic log backup is on, then the database system automatically backs up the redo log entries to backup files.

    • File name and complete path to the data carrier for the initial data backup

    • File name and complete path to the data carrier for log backups

    More information: Database Administration, Backing Up Log Entries

  6. Check your configuration.

  7. To create the database, choose Start.

    The database is created.

    Note that in addition to the database system administrator, the following users are created:

    • First DBM operator: user name DBM, same password as the database system administrator

    • If you have loaded the tutorial data during the creation of the database:

      Database user of type DBA: user name MONA, password RED

Advanced Mode
  1. Enter the following data:

    Property

    Description

    Database Server

    Name or IP address of the computer on which you want to create the database

    To create the database on the local computer, leave the field blank or enter <Local>.

    Database Name

    More information: Database Administration, Conventions for Database Names

    Login Name

    Only necessary if you create the database on a remote computer

    Name of the operating system user on the remote computer

    Password

    Only necessary if you create the database on a remote computer

    Password of the operating system user on the remote computer

  2. Select the version and path of the database software you want to use to create the database.

  3. Enter the following data:

    Creating Database in Advanced Mode: Advanced Options

    Property

    Description

    Windows Service

    • Set the startup type for the database service to Automatic

    • Use the login information as the account for the database service

    On Microsoft Windows only

    • Select this option if you want the database to be automatically started when you start your computer.

    • If you create a database on a remote Microsoft Windows computer, selecting this option means that the user name you provide will also be used as the user for the database service that is created.

    Automatic extension of data area

    The data of a database is permanently stored in the data volumes (data area). If the data area of a database is full, the database stops working. If you activate the automatic extension of the data area for your database, the system adds a new data volume as soon as the configured fill level of the data area is reached.

    More information: Activating or Deactivating the Automatic Extension of the Data Area

    Automatic update of statistics

    The database system needs the SQL Optimizer statistics to determine the optimal search strategy for accessing data when executing complex SQL statements.

    If you activate automatic update of statistics, the system automatically updates the SQL Optimizer statistics when necessary.

    More information: Updating SQL Optimizer Statistics

  4. Enter the user name and password for the first DBM operator.

    More information: Database Administration, DBM Operators

  5. Choose how to configure the database parameters:

    • Initialize parameters with default values

      Choose the database type in the next step.

    • Copy parameters from existing database

      Choose the database from which to import the database parameters in the next step.

    • Restore parameters from a backup

      Choose the backup from which to restore the database parameters in the next step.

  6. Adjust the database parameters if necessary.

    More information: Database Administration, Database Parameters

  7. The system saves the data and log entries of the database in the volumes.

    You can change the configuration of the first data volume and the first log volume or add new volumes.

  8. Choose the database creation mode:

    • Create and start database

      Enter a password for the database system administrator.

      After it has been created, the new database is started.

    • Create database for recovery

      After it has been created, the new database is transferred to the ADMIN operational state.

      Note that 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.

  9. Configure additional database properties.

    Property

    Description

    Load tutorial data

    More information: Concepts of the Database System, Demo Database

    Activate overwrite mode for the log area

    More information: Glossary, Overwrite Mode for the Log Area

    Automatic log backup:

    • Initial complete data backup

    • Log backup

    If automatic log backup is on, then the database system automatically backs up the redo log entries to backup files.

    • File name and complete path to the data carrier for the initial data backup

    • File name and complete path to the data carrier for log backups

    More information: Database Administration, Backing Up Log Entries

  10. Check your configuration.

  11. To create the database, choose Start.

    The database is created.