Creating Databases

Prerequisites

You can create databases using Database Studio or Database Manager CLI. For stand alone databases, that is for SAP MaxDB database systems which are not part of an SAP system, you can also use Installation Manager. If you want to use Database Studio or Database Manager CLI to create a database, install the database software first.

For more information about installing the database software, see: Glossary, Installation.

Procedure

Plan the database.
More information: Planning Databases

Create the database.

More information:

Database Studio, Creating Databases

When you create a database, you specify the following properties, among others:

Important Database Properties
Property	Restrictions	Modifiable	More Information
Database name	Conventions for Database Names	No	-
Database System Administrator: Name and password	Conventions for User Names and Passwords	Name: No Password: Yes	Managing Users
Data area (data volumes): Size (=database size), directory, automatic extension Log area (log volumes): Size and directory	General database parameters `MaxDataVolumes` and `MaxLogVolumes` More information: Planning Databases	Yes	Changing the Database Size Database Parameters
Working memory used by the database	General database parameter `CacheMemorySize` 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.	Yes	General Database Parameters Working Memory Areas
Number of CPUs	General database parameter `MaxCPUs`	Yes	General Database Parameters
Maximum number of parallel database sessions	General database parameter `MaxUserTasks`	Yes	General Database Parameters
Maximum number of locks	General database parameter `MaxSQLLocks`	Yes	Configuring Locks for Database Objects
Automatic update of the SQL optimizer statistics	For SAP systems, see SAP note 927882.	Yes	Automating Administration Tasks
Automatic log backup	-	Yes	Automating Administration Tasks
Automatic database start	Only available on Microsoft Windows	Yes	Activating Automatic Database Start
Log settings	-	Yes	Configuring Database Transaction Logging

You can change most of these properties later. More information: Changing Database Properties

When you create a database, you can also load demo data and demo users. More information: Concepts of the Database System, Demo Database

The system starts the database.
You can now log on to the database.

More information:
- Database Studio, Logging On to a Database
- Database Manager CLI, Calling Database Manager CLI
- Database Administration in CCMS, MaxDB/liveCache System Overview
Only in SAP systems: You can configure encryption.
More information: Encryption
Create the tables and other database objects in the database.

Database Objects
Tables

View tables

Synonyms

Indexes

Database users

Schemas

Triggers

Database procedures

Database functions

More information:
- Database Studio, Creating and Using Database Objects: Overview
- SQL Tutorial, Data Definition
Create the required database users and assign authorizations.
More information: Database Users
Insert the data into the database.
More information:
- Database Studio,
  - Changing Data in the Database
  - Importing Data and/or Information from the Database Catalog
- SQL Tutorial, Data Manipulation

Database Objects
Tables
View tables
Synonyms
Indexes
Database users
Schemas
Triggers
Database procedures
Database functions

More Information

Concepts of the Database System, What is an SAP MaxDB Database?

Installation and Upgrade Documentation (SAP MaxDB in SAP Systems)
Title of the Documentation	Description
SAP NetWeaver <shipment> on <operating_system>: SAP MaxDB	Only for SAP customers Only in English You can find this guide on the SAP Service Marketplace at http://service.sap.com/instguides. For more information, see SAP Note 767598.
Upgrade to SAP MaxDB Database <version> <operating_system>	Only for SAP customers Only in English You can find this guide on the SAP Service Marketplace at http://service.sap.com/instguides. For more information, see SAP Note 767598.