You can change most database properties.
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 |