Quick Beginnings for DB2 Extended Enterprise Edition for UNIX

Chapter 17. Working with Instances

The information in this section describes DB2 server instances and how to work with them.

An instance is a logical database manager environment where you catalog databases and set configuration parameters. Depending on your needs, you can create more than one instance. You can use multiple instances to do the following:

• Use one instance for a development environment and another instance for a production environment.

• Tune an instance for a particular environment.

• Restrict access to sensitive information.

• Control the assignment of SYSADM, SYSCTRL, and SYSMAINT authority for each instance.

• Optimize the database manager configuration for each instance.

• Limit the impact of an instance crash. In the unlikely event of an instance crash, only one instance is impacted. The other instance may continue to function normally.

Each additional instance requires additional system resources (virtual storage and disk space) and more administration.

[ DB2 List of Books | Search the DB2 Books ]