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