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.
Plan the database.
More information: Planning Databases
Create the database.
Recommendation
If you want to operate several databases, then create each database on a separate computer.
More information:
Database Studio, Creating the Database
Database Manager CLI Tutorial, Creating/Configuring a Database
You can use templates. More information: Database Templates
When you create the database, you specify the following properties, among others:
Property |
Restrictions |
Modifiable |
---|---|---|
Database name |
No |
|
Database System Administrator: Name and password |
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
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, User Menu
Only in SAP systems: You can activate data encryption.
More information: Encryption
Create the tables and other database objects in the database.
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,
SQL Tutorial, Data Manipulation
Concepts of the Database System, What is an SAP MaxDB Database?
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. |