Creating Databases 
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
In the context menu of Servers, choose
Administration Tasks 
Create Database... 
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)
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
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
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
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)
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
Check your configuration.
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
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
Select the version and path of the database software you want to use to create the database.
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
Enter the user name and password for the first DBM operator.
More information: Database Administration, DBM Operators
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.
Adjust the database parameters if necessary.
More information: Database Administration, Database Parameters
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.
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.
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
Check your configuration.
To create the database, choose Start.
The database is created.