Background documentationDatabase Locate this document in the navigation structure

 

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.

Important Database Properties

Property

Restrictions

Modifiable

More Information

Database name

Conventions for Database Names

No

-

Database System Administrator: Name and password

Conventions for User Names and Passwords

Name: No

Password: Yes

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

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

Configuring Locks for Database Objects

Automatic update of the SQL optimizer statistics

For SAP systems, see SAP note 927882.

Yes

Automating Administration Tasks

Automatic log backup

-

Yes

Automating Administration Tasks

Automatic database start

Only available on Microsoft Windows

Yes

Activating Automatic Database Start

Log settings

-

Yes

Configuring Database Transaction Logging

More Information