Creating a Database Instance: Custom 

Using Custom, you can create a database instance on a local or remote computer using the Database Manager GUI. You can change all presettings for database parameters, volumes and so on for this database instance individually.

Prerequisites

Note the usual prerequisites when Creating a Database Instance.

Procedure

Choose Instance ® Create... .

Choose Next to start each of the required steps. Choose Custom.

       1.      To create a database instance on your local computer, enter the following:

○     Database Server: <local>: Do not change this entry.

○     Database Name: Name of database instance (see also: Concepts of the Database System, Conventions for Database Names). In the demo environment, DEMODB is used for the name of the database instance.

To create a database instance on a remote computer, enter the following in addition:

○     Database Server: Name of the remote computer

○     Port: Port used to address the X Server. If you do not specify a port, the default port is used (see X Server, Ports and Protocols of the X Server).

○     Login Name: Operating system user for the remote computer

○     Password: Password for the operating system user on the remote computer

       2.      A computer can have multiple installations of the database software. Select the appropriate installation.

       3.      If you are using a Microsoft Windows operating system, you can specify further options:

○     Set the startup type for the database service to automatic: The database instance is started automatically when the computer is started (see: Concepts of the Database System, Automatic Start).

○     Use the login information as account for the database service: For remote computers only. The service for the database instance runs on remote computers under the name of the operating system user logged on and not under SYSTEM.

○     Automatic extension of data areas: The data area is extended automatically where there is insufficient memory space (see: Switching on/off Automatic Extension of the Data Area).

○     Automatic update of statistics: Statistics for the SQL Optimizer are updated automatically (see also: Updating Statistical Information).

       4.      Specify the Database Manager Operator (DBM operator). In the demo environment, DBM is used both as the name and password for the Database Manager operator.

Select Use Encryption if you want to encrypt communications between the client and the X Server (See: Concepts of the Database System, Data Encryption).

The name and password of the DBM operator are converted to upper case by the database system (See: Concepts of the Database System, Conventions for User Names and Passwords).

       5.      Decide how you want to assign initial values to the database parameters.

○     Initialize parameters with default values
In this case, the database parameters are assigned the default values of the database software.

○     Copy parameters from existing database
In this case, the initial values of the database parameters are taken from an existing database instance. Choose the database instance from which you want to copy the parameter values.

○     Restore parameters from a backup medium
In this case, the initial values of the database parameters are taken from a complete data backup. Select the complete data backup you want.

       6.      Choose a database instance type.

       7.      Adjust the database parameters (General/Extended) as required. To change a database parameter, select the database parameter and choose New Value. Enter the new value for the database parameter and confirm this. The database parameters are checked when you exit the input screen. You may be asked to perform changes and confirm these before you are allowed to exit the input screen (see: Concepts of the Database System, Database Parameters)

       8.      Define your data volumes and log volumes.

You can copy the proposed values or change them as required.
To define new volumes, choose New Volume and enter the size as well as the name or absolute path of the volume.

       9.      Choose from the following options:

○     Create and start instance
Specify the database system administrator (SYSDBA user). Do not use special characters and do not choose the name SYSDBA. We recommend using upper case (see: Concepts of the Database System, Conventions for User Names and Passwords). In the demo environment DBADMIN and SECRET used as the name and passwordrespectively for the database system administrator.

○     Create instance for recovery
The database instance is created and transferred to the ADMIN operational state. You can use this database instance for a restore only. The details for the database system administrator (SYSDBA user) are transferred from the data backup.

...

       1.      You can also make further settings:

○     Select Load Tutorial if you want to load all demo data straight away (see: Concepts of the Database System, Demo Database).
If you do not select Load Tutorial, the demo data is not loaded when the database instance is created. You can load the demo data at a later point in time however. In such cases, proceed as described in Loading Demo Data.

○     Select Activate overwrite mode for the log area if you wish to activate overwrite mode for the log areas (Concepts of the Database System, Log settings).
If you do not select Activate overwrite mode for the log area, overwrite mode is deactivated, that is, a full log area cannot be overwritten until after the log entries have been backed up. You should therefore activate automatic log backup. You can activate overwrite mode later on. In such cases, proceed as describedin Changing Log Settings.

○     Select Automatic log backup if you wish to activate automatic log backup (Concepts of the Database System, Backing up Log Entries).
If you do not select Automatic log backup, automatic log backup is not activated after a database instance has been created. You can activate this at a later point in time however. In such cases, proceed, for example, as described in Switching on/off Automatic Log Backup.

       2.      If you want to save your configuration as a template for creating database instances, choose Save Template as... (see Concepts of the Database System, Templates for Database Instances).

       3.      Choose Start. If errors occur, the procedure is terminated immediately. However, the state reached before the error occurred is preserved.

       4.      Select Close to close the wizard.

Result

The database instance is created in accordance with your entries and transferred to the ONLINE operational state.

In addition to the necessary users, volumes and so on, an initial backup template called INITIALBACKUP is created and data is backed up to this template. To create additional backup templates, proceed as described in Managing the Backup Templates. To carry out additional backups, proceed as described in Backup Procedures.

See also:

Concepts of the Database System

●     Creating and Configuring a Database Instance

●     Users, Authentication and Authorizations

●     Backup Templates and Data Carriers