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
(Microsoft Windows)*

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
(Microsoft Windows)**

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