Template
for Database Instances 
Use
Installation Manager and Database Manager GUI provide templates for creating a database instance, in which the most important properties of the database instance are already configured.
Features
The Installation Manager offers additional templates for SAP installations.
Desktop PC / Laptop
Use this template to create a database instance that is designed for a single user. You can use this database instance to develop simple database applications, carry out tests and work through the examples described in the MaxDB tutorials.
Property |
Default Value |
Database name |
MAXDB1 |
Run directory |
C:\Documents and Settings\All Users\Application Data\sdb\data\wrk\MAXDB1\ |
Data volumes |
● Directory C:\Documents and Settings\All Users\Application Data\sdb\data\MAXDB1\data\ ● Size of the first data volume 256 MB |
Log volumes |
● Directory C:\Documents and Settings\All Users\Application Data\sdb\data\MAXDB1\log\ ● Size of the first log volume 50 MB |
Size of the data cache and converter (database parameter CACHE_SIZE) |
2500 pages (approximately 20 MB) |
Amount of CPUs (database parameter MAXCPU) |
1 |
Parallel database sessions (database parameter MAXUSERTASKS) |
10 |
Unicode support (database parameter _UNICODE) |
YES |
Automatic start |
Switched on |
Log settings |
● Log mode: not mirrored ● Overwrite mode for the log area: switched on ● Redo log management: switched on |
Automatic log backup |
Switched off |
Automatic extension of the data area |
Switched on |
Automatic updating of statistics |
Switched on |
Name of the Database System Administrator (SYSDBA User) |
DBADMIN |
Name and password of the first DBM operator. |
DBM/DBM |
Names and passwords for database users |
DBSERVICE/SECRET MONA/RED |
* The same properties are configured for UNIX/Linux, with the following exceptions:
● Working directory: /var/opt/sdb/data/wrk/MAXDB1/
● Data volumes/directory: /var/opt/sdb/data/MAXDB1/data/
● Log volumes/directory: /var/opt/sdb/data/MAXDB1/log/
● Automatic start: this function is not available
Custom
Use this template to create a database instance that is designed for large applications and multiple users.
Property |
Default Value |
Database name |
MAXDB1 |
Run directory |
C:\Documents and Settings\All Users\Application Data\sdb\data\wrk\MAXDB1\ |
Data volumes |
● Directory C:\Documents and Settings\All Users\Application Data\sdb\data\MAXDB1\data\ ● Size of the first data volume 1024 MB |
Log volumes |
● Directory C:\Documents and Settings\All Users\Application Data\sdb\data\MAXDB1\log\ ● Size of the first log volume 50 MB |
Size of the data cache and converter (database parameter CACHE_SIZE) |
91648 pages (716 MB) |
Amount of CPUs (database parameter MAXCPU) |
1 |
Parallel database sessions (database parameter MAXUSERTASKS) |
20 |
Unicode support (database parameter _UNICODE) |
YES |
Automatic start |
Switched on |
Log settings |
● Log mode: not mirrored ● Overwrite mode for the log area: switched off ● Redo log management: switched on |
Automatic log backup |
Switched on |
Automatic extension of the data area |
Switched on |
Automatic updating of statistics |
Switched off |
Name of the Database System Administrator (SYSDBA User) |
DBADMIN |
Name of the first DBM Operator |
DBM |
** The same properties are configured for UNIX/Linux, with the following exceptions:
● Working directory: /var/opt/sdb/data/wrk/MAXDB1/
● Data volumes/directory: /var/opt/sdb/data/MAXDB1/data/
● Log volumes/directory: /var/opt/sdb/data/MAXDB1/log/
● Automatic start: this function is not available
See also:
Creating and Configuring a Database Instance