Creating and Configuring a Database Instance

Purpose

To create and configure a database instance, you can use either the Installation Manager or the Database Manager database tool.

Prerequisites

If you use the Database Manager to create a database instance, you first have to install the database software (see the Installation Manual).

Process Flow

...

       1.      You plan your database instance.

See

0     Planning the Database Instance

0     Technical Restrictions

       2.      You create the database instance.

See

0     Installation Manual, Using the Installation Manager

0     Database Manager GUI, Creating a Database Instance

0     Database Manager CLI, db_create

0     Database Administration Tutorial, Creating and Configuring a Database Instance

You can use templates (see Templates for Database Instances ).

When you create the database instance, you configure the following properties, among others:

0     Database name (see Conventions for Database Names)

0     Data and log volumes (size, directories)

0     Values of important database parameters (see Database Parameters)

Use the special database parameter _UNICODE to determine whether the names of database objects in the database catalog, such as tables and column names, are to be stored in Unicode. You can not change this database parameter once the database has been created.

0     Other operating properties (see, for example, Automatic Start and Log Settings)

0     First users (see Users, Authentication and Authorizations)

       3.      The database system transfers the database instance to the ONLINE operational state.

Result

The database instance is ready for operation. You can now create tables and insert data in the database instance (see Database Design).

See also:

Configuration Files

MaxDB Security Guide

Installation Manual, Directories