Creating Databases

You can create a database during the installation process of the database software.

You can also create databases after having installed the database software using Database Studio or Database Manager CLI. If you want to use Database Studio, install the Database Studio software package. Database Manager CLI needs not be installed separately since it is part of the database software installation package.

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

1. Plan the database.

   More information: Planning Databases

2. Create the database.

   More information:

   Database Studio, Creating Databases

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

   Table 1: 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
   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 tutorial (demo) data and demo users. More information: Concepts of the Database System, Demo Database

3. 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

4. Only in SAP systems: You can configure encryption.

   More information: Encryption

5. Create the tables and other database objects in the database.

   Table 2: 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

6. Create the required database users and assign authorizations.

   More information: Database Users

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

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