Database Templates
When you create a database during installation with Installation Manager, you can choose between different database templates with pre-defined properties. You can change most of these properties later.
Desktop PC / Laptop Template
Use this template to create a database that is designed for a single user. You can use such a database to develop simple database applications, carry out tests and work through the examples described in the tutorials.
|
Property |
Default Value (Microsoft Windows)* |
|---|---|
|
Database Name |
MaxDB |
|
Database System Administrator |
DBADMIN |
|
Database Manager Operator |
DBM |
|
Tutorial User |
MONA (password RED) |
|
Data Volume |
Name: DISKD0001 Directory: C:\ProgramData\sdb\data\MaxDB\volumes\data\ Size of the first data volume: 256 MB |
|
Log Volume |
Name: DISKL0001 Directory: C:\ProgramData\sdb\data\MaxDB\volumes\log\ Size of the first log volume: 50 MB |
|
Automatic Statistics Update |
On |
|
Automatic Start on System Reboot |
On |
|
Log Settings |
No log backup (overwrite mode) |
|
Memory (Size of the data cache and converter, database parameter CacheMemorySize) |
19 MB |
|
CPUs (Number of CPUs, database parameter MaxCPUs) |
1 |
|
* The same properties are used on Unix and on Linux, with the following differences:
|
Custom Template
Use this template to create a database that is designed for large applications and multiple users.
|
Property |
Default Value (Microsoft Windows)** |
|---|---|
|
Database Name |
MaxDB |
|
Database System Administrator |
DBADMIN |
|
Database Manager Operator |
DBM |
|
Data Volumes |
Name: DISKD0001 Directory: C:\ProgramData\sdb\data\MaxDB\volumes\data\ Size of the first data volume: 250 MB |
|
Log Volumes |
Name: DISKL0001 Directory: C:\ProgramData\sdb\data\MaxDB\volumes\log\ Size of the first log volume: 50 MB |
|
Memory (MB) Size of the data cache and converter (database parameter CacheMemorySize) |
175 MB |
|
CPUs Number of CPUs (database parameter MaxCPUs) |
1 |
|
Parallel Database Sessions |
20 |
|
Automatic Start on System Reboot |
Activated |
|
Automatic Extension of the Data Area |
Activated |
|
Automatic Statistics Update |
Activated |
|
Log Settings |
Automatic Log Backup Function is activated |
|
* The same properties are used on Unix and on Linux, with the following differences:
|
Glossary, Directory