You use the Installation Wizard in the Database Manager GUI to install or initialize database instances on a local or remote server. The Installation Wizard guides you through the entire process.
For a local installation, you must have the administration authorizations of an operating system user for this server.
To initialize a local database instance, you also need the administration authorizations for this database instance.
For an installation on a remote server, you must specify an operating system user for this server that has administration authorizations, and also the authorization log on as batch job, or a similar authorization. (For more information on the administration of operating system users, see your operating system documentation.)
To initialize a database instance on a remote server, you also need the administration authorizations for this database instance.
...
Start the Installation Wizard. To do this, choose Start ® Programs ® MySQL MaxDB ® Database Manager Wizards ® Installation Wizard or, in Database Manager GUI, choose Instance ®Installation Wizard.
Choose Next to start each of the required steps.
1.
Select the
appropriate template for the installation.
If you want to install or initialize a new database instance, choose
New.
If you want to install a preconfigured database instance, select one of
the installed templates (such as Demo), or a template of your own. If
you use a template for the installation, you can install the database instance
in the background. To do this, choose Unattended
Installation.
2.
Enter the
following details:
Database instance on your local server:
Database Server: <local>: Do not change this entry.
Database
name
- Installation of a database instance: Enter the name of the new database.
- Initialization of a database instance: Enter the name of the database
instance that you want to initialize.
Database instance on a remote server:
Database Server: Enter the name of the server.
Database Name
- Installation of a database instance: Enter the name of the new database.
- Initialization of a database instance: Enter the name of the database
instance that you want to initialize.
Login Name: Enter the operating system user for this server.
Password: Enter the password for this operating system user.
3. There may be more than one installation of the database software on the same server. Select the appropriate installation.
4. Specify the Database Manager operator (DBM operator). Do not use any special characters. The default name is DBM. Enter and confirm the password.
The Database Manager saves the name and password of the DBM operator in uppercase letters.
5. Decide how you want to give the database parameters initial values.
Initialize parameters with default values
The
initial values of the database parameters are taken from the standard
configuration used for the installation of the database
software.
Copy parameters from existing database
The initial
values of the database parameters are taken from their configuration in an
existing database instance.
Select the database instance from which you want to copy the parameter
file.
Restore parameters from a backup medium
The initial
values of the database parameters are taken from their configuration in a complete data
backup.
Select the complete data backup that you want to use.
Use current parameters
You can take the
current database parameter values from an existing database
instance.
6.
Select a database instance
type.
If you chose Use current parameters, the system uses the instance type
of the existing database instance.
7.
Adjust the
database parameters to your requirements.
Select the database parameters you want.
New Value: Enter and confirm the new value of
the database parameter.
The value of the database parameter is stored in the internal data structures
and becomes effective when the database instance is next restarted.
The database parameters are checked when you exit the input screen. You may be prompted to make and confirm changes before you can leave this screen.
8. Define your data volumes and log volumes.
Choose New Volume for both.
Enter the size and ID or the absolute path of the volume and confirm your
entries.
9. Define any backup media that you need.
10. Choose from the following options:
Install and start instance
Specify the
database
system administrator (SYSDBA user). The default name is DBA. Enter and
confirm the password.
The database instance is installed or initialized and transferred to
the operational state
ONLINE.
Install instance for recovery
The database
instance is installed or initialized and transferred to the operational state
ADMIN. You can use this database instance for a recovery only.
The Installation Wizard starts the Recovery Wizard.
The details of the SYSDBA user are taken from the data backup.
11. Choose Start to install or initialize the database instance.
If any errors occur, the process is stopped immediately. However, the state reached when the error occurred is preserved.
12. Close the Installation Wizard.
You can save the details you enter when you install or initialize a database instance in a template. The Installation Wizard proposes a path and name for the template. You can use this template to install and initialize other database instances.