Procedure documentationChanging Database Properties Locate this document in the navigation structure

 

You can change most database properties.

Procedure

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