Procedure documentationCreating Databases Locate this document in the navigation structure

Prerequisites

You can create databases using Database Studio, or Database Manager CLI. For stand-alone systems, 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 on installation and Installation Manager , see: Glossary, Installation.

Procedure

  1. Plan the database.

    More information: Planning Databases

  2. Create the database.

    Recommendation Recommendation

    If you want to operate several databases, then create each database on a separate computer.

    End of the recommendation.

    More information:

    You can use templates. More information: Database Templates

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

    Important Database Properties

    Property

    Restrictions

    Modifiable

    Database name

    Conventions for Database Names

    No

    Database System Administrator: Name and password

    Conventions for User Names and Passwords

    Name: No

    Password: Yes

    More information: 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

    More information:

    Size of the data cache and converter

    General database parameter CacheMemorySize

    Yes

    Number of CPUs

    General database parameter MaxCPUs

    Yes

    Maximum number of parallel database sessions

    General database parameter MaxUserTasks

    Yes

    Maximum number of locks

    General database parameter MaxSQLLocks

    Yes

    More information: Configuring Locks

    Automatic update of the SQL optimizer statistics

    For SAP systems, see SAP note 927882.

    Yes

    More information: Automating Administration Tasks

    Automatic log backup

    -

    Yes

    Automatic database start

    Only available on Microsoft Windows

    Yes

    More information: Activating Automatic Database Start

    Log settings

    -

    Yes

    More information: Configuring Logging

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

    When you create the database, you can also load 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:

  4. Only in SAP systems: You can activate data encryption.

    More information: Encryption

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

  6. Create the required database users and assign authorizations.

    More information: Database Users

  7. Insert the data into the database.

    More information:

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 7.1 <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 7.7: <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.