A database is a set of data with a regular structure. To create and manage databases, you use database software. To access and change data in a database, you use SQL statements.
Property |
Restrictions |
Modifiable |
More Information |
---|---|---|---|
Database name |
No |
- |
|
Database System Administrator: Name and password |
Name: No Password: Yes |
||
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 |
|
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 |
|
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 |
|
Automatic update of the SQL optimizer statistics |
For SAP systems, see SAP note 927882. |
Yes |
|
Automatic log backup |
- |
Yes |
|
Automatic database start |
Only available on Microsoft Windows |
Yes |
|
Log settings |
- |
Yes |
Concepts of the Database System, What is an SAP MaxDB Database?
Database Administration, Creating Databases
Database Studio, Creating Databases
Database Manager CLI, db_create
SQL Reference Manual, SQL Statements: Overview
SQL Tutorial, SQL Tutorial
Database Administration in CCMS, Properties