Background documentationDatabase Templates Locate this document in the navigation structure

 

Database Studio provides several database templates for creating databases with predefined properties.

You can change most of these properties later. More information: Changing Database Properties

Desktop/Laptop Template

Use this template to create a database that is designed for a single user. You can use this database to develop simple database applications, carry out tests and work through the examples described in the tutorials.

Desktop/Laptop Template

Property

Default Value (Microsoft Windows)*

Database name

MAXDB1

Name of the database system administrator (SYSDBA User)

DBADMIN

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

Automatic extension of the data area

Activated

Automatic log backup

Deactivated

Automatic update of the SQL optimizer statistics

Activated

Automatic database start

Activated

Log settings

Log mode: not mirrored

Overwrite mode for the log area: activated

Redo log management: activated

Size of the data cache and converter (database parameter CacheMemorySize)

2500 pages (approximately 20 MB)

Number of CPUs (database parameter MaxCPUs)

1

Maximum number of parallel database sessions (database parameter MaxUserTasks)

10

Name and password of the first DBM operator

DBM/DBM

Names and passwords of database users

DBSERVICE/SECRET

MONA/RED

Run directory

C:\Documents and Settings\All Users\Application Data\sdb\data\wrk\MAXDB1\

* The same properties are configured for Unix/Linux, with the following exceptions:

  • Run 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: function not available

Custom Template

Use this template to create a database that is designed for large applications and multiple users.

Template: Custom

Property

Default Value (Microsoft Windows)**

Database name

MAXDB1

Name of the database system administrator (SYSDBA User)

DBADMIN

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

Automatic extension of the data area

Activated

Automatic log backup

Activated

Automatic updating of the SQL optimizer statistics

Deactivated

Automatic database start

Activated

Log settings

Log mode: not mirrored

Overwrite mode for the log area: deactivated

Redo log management: activated

Size of the data cache and converter (database parameter CacheMemorySize)

91648 pages (716 MB)

Number of CPUs (database parameter MaxCPUs)

1

Parallel database sessions (database parameter MaxUserTasks)

20

Name of the first DBM Operator

DBM

Run directory

C:\Documents and Settings\All Users\Application Data\sdb\data\wrk\MAXDB1\

** The same properties are configured for UNIX/Linux, with the following exceptions:

  • Run 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: function not available

More Information

Glossary, Directory