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 |
|
Search This Blog
Thursday, July 1, 2010
Changing SAP MaxDB Database Properties
Labels:
Database
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment