Search This Blog

Thursday, July 1, 2010

Changing SAP MaxDB 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

 

Data area (data volumes): Size (=database size), directory, automatic extension
Log area (log volumes): Size and directory

General database parameters MaxDataVolumes and MaxLogVolumes

 

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

 

Maximum number of parallel database sessions

General database parameter MaxUserTasks

Yes

 

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

 

No comments:

Post a Comment