Creating a New Database Instance 

Prerequisites

If the database instance is to be created locally and the operating system Windows NT or Windows 2000 is installed on your server, then the user logged onto the operating system must possess administration rights.

1. Enter the name of the new database instance. This name must be unique to the server and be no longer than 8 characters.
   If you want to create the database instance on a remote server, enter the name of the server as well as your user name and password for this server.
   Choose Next.
2. There may be more than one installation of the database software on the same server. The different installations may also be of different versions. Of the installations present on the server, select the one you want.
   Choose Next.
3. Enter the Database Manager users DBM and DBA and assign passwords for DBM and DBA.
   Choose Next.
4. Select one of the following options:
   
   Initialize parameters with default values
   When the parameter file for the database instance is created, the standard configuration stored when the database software was installed is used.
   Choose an instance type for the database.
   
   Use current parameters
   You reinstall an existing database instance and copy its parameters.
   
   Copy parameters from existing database
   You want to use the configuration of a database instance on the server.
   Select the database instance from which the parameter file is to be copied.
   
   Restore parameters from a backup medium
   You want to use the parameter file in a complete data backup to create the new database instance. Select the complete data backup you want.
5. Adjust the parameters to your requirements. Select the required parameters and then choose Edit.
   It now appears in the bottom part of the window. Next to the parameter you will see an explanation of what the parameter does and, in some cases, how it is calculated.
   
   Enter the new value for the parameter in the New Value field and confirm your entry.
   The new value appears in the New Value column. It is stored in the internal data structures and becomes effective once the database instance is restarted.
   
   Choose Next.
   
   When you exit the input screen, the parameters are checked following the rules stored on the server. You may be asked to make and confirm changes before you are permitted to exit the input screen.
6. Define the properties of the log devspaces and the data devspaces. When doing so, bear in mind the parameters set in the previous step.
   
   Select a devspace and then choose Edit. Enter the size and ID (or absolute path) of the devspace and confirm your entries. Repeat for each devspace.
   
   Choose Next.
7. Choose between the following options:
   
   Install instance
   The database instance is created with the parameters specified under point 5.
   
   Restore Instance
   The database instance is re-initialized with the parameters under point 5. It must then be restored using the Database Manager.
   
   Choose Next.
8. Choose Install to start installing the new database instance or initialize the selected instance.
   
   You can see how the generation or initialization of the database instance is progressing. If any errors occur, the process is stopped immediately. However, the state that had been reached when the error or fault occurred is preserved.
   
   Before you complete this step, the system prompts you to enter the name under which the database instance should be registered in the Database Manager GUI. Confirm your entries.
9. Select Close to close the Database Wizard.
   You are taken back to the start screen of the Database Manager GUI.

Once a new database instance has been created, its status is ONLINE.

After an existing database instance has been initialized, its status is ADMIN and can be restored straight away.