Database Templates

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