Creating Databases 
Note
You can create databases using the Installation Manager also when installing the software.
More information: Installation Manual, Using the Installation Manager
Prerequisites
You are logged on to the computer on which you want to create the database as an operating system user.
To create a database in Unix/Linux systems, you must be logged on as the root operating system user or a member of the sdba operating system user group.
More information: Database Management, Special Operating System Users and User Groups (Unix/Linux)
To create a database on a remote computer, the X Server must be running on the remote computer.
If the database software has been installed on Microsoft Windows, the system sets the Startup Type for the X Server to Automatic so that it is started automatically when the computer is started.
For Unix/Linux systems, you have to start the X Server of the remote database computer explicitly to be able to manage a database on this computer. More information: X Server, Starting the X Server
To create a database on a remote computer that uses Microsoft Windows, you must have administration rights for the remote computer as well as log on as batch job authorization.
More information: Operating System Documentation
Procedure
Choose Create Database... in the context menu of Servers.
Enter the following data:
Property
Description
Database Server
Name or IP address of the server where you want to create the database
To create the database on the local server, leave the field blank or enter <Local>.
Database Name
Database name
More information: Database Administration, Conventions for Database Names
Login Name
Only necessary if you create the database on a remote server
Name of the operating system user on the remote server
Password
Only necessary if you create the database on a remote server
Password of the operating system user on the remote server
Enter the following information:
Property
Description
User Name
Name of the database system administrator
More information: Database Administration, Database System Administrator
Password
Password of the database system administrator
More information: Database Administration, Conventions for User Names and Passwords
Installation
Version and folder of the software you want to use to create the database
You use database parameters to configure important database properties. You can now change the default values of some of these database parameters.
Property
Database Parameters
Description
Memory Cache Size
CacheMemorySize
Size of the memory cache used by the database
Max. User Tasks
MaxUserTasks
Maximum number of user tasks (number of database users that can be logged on to the database concurrently)
Max. SQL Locks
MaxSQLLocks
Maximum number of SQL blocks
Run Directory Path
RunDirectoryPath
Path of the database Working Directory
More information: Database Management, General Database Parameters
The system saves the database data and log entries in the volumes. You can now change the default values for the properties of the first data volume and the first log volume.
Property
Database Parameters
Description
Memory Cache Size
CacheMemorySize
Size of the memory cache used by the database
Max. User Tasks
MaxUserTasks
Maximum number of user tasks (number of database users that can be logged on to the database concurrently)
Max. SQL Locks
MaxSQLLocks
Maximum number of SQL blocks
Run Directory Path
RunDirectoryPath
Path of the database Working Directory
More information: Concepts of the Database System, Volumes (Permanent Storage)
Define additional database properties.
Property
Description
Load tutorial data
Load the complete tutorial data
You can also the tutorial data later.
More information: Concepts of the Database System, Demo Database
Activate overwrite mode for the log area
Switch on overwrite mode for the log area
More information: Glossary, Overwrite Mode for the Log Area
Automatic log backup:
Initial complete data backup
Log backup
If automatic log backup is on, then the database system automatically backs up the redo log entries to backup files.
File name and complete path to the data carrier for the initial data backup
File name and complete path to the data carrier for log backups
More information: Database Administration, Backing Up Log Entries
Check the selected settings.
To create the database, choose Start.
More Information
Database Administration, Creating and Configuring a Database