Create multiple database instances 

Create multiple instances of a database for a more versatile database environment.


Before starting

This is an optional procedure. If you need to have only one database instance (or, in Oracle terminology, one database), you can skip this task.

(Windows™ only) Complete the following steps for each instance that you plan to create:

  1. Create a new user and add it to the Administrators and DB2ADMNS groups.

  2. Remove the user account from the Users group.

  3. In the Local Security Policy utility, add these rights to the new user:

    • Act as part of the operating system

    • Adjust memory quotas|Increase quotas for a process

    • Create a token object

    • Debug programs

    • Lock pages in memory

    • Log on as a service

    • Replace a process level token

Note: The new account uses the local system as the domain.


About this task

A database environment with multiple instances provides the flexibility to tune an instance for a particular configuration, use different instances for development and production, restrict access to sensitive information, and optimize the database manager configuration for each instance. For example, if you need to make changes to one of the instances, you can restart just that instance instead of the whole system. Similarly, if you need to take an instance offline, only the databases that are hosted on that instance are unavailable during the outage, while your other databases are unaffected.

DB2 only. If you are hosting IBM DB2 on a single 32-bit system, you should create multiple DB2 instances. A single DB2 instance on a 32-bit system can manage a maximum of 2 GB of data in memory and this can become a constraint when you install multiple IBM Connections applications. At a minimum, create two DB2 instances when you are installing all the applications, but also consider creating separate instances for the Activities and Communities databases because they are usually the most memory-intensive databases. Ideally, you would install one DB2 instance per IBM Connections application. If you are hosting DB2 on a 64-bit system, you do not need to create multiple instances, provided the system has sufficient RAM.

Multiple instances require additional system resources.

To create multiple instances of a database...

Choose your database type:


What to do next

When you create multiple database instances, install the databases on each instance. If you are using the database wizard to install the databases, prepare and run the database wizard once for each instance and if you are using the scripts to install the databases, run the scripts once for each instance.


Parent topic

Create databases


Related tasks


Registering the DB2 product license key
Create a dedicated DB2 user
Create databases with the database wizard
Create databases with SQL scripts
Enable NO FILE SYSTEM CACHING for DB2 on System z

Related reference
http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.admin.doc/doc/c0004900.htm

+

Search Tips   |   Advanced Search