IBM Books

Administration Getting Started


Starting and Stopping an Instance

In this book you use the default instance that was created when DB2 was installed. It is called DB2. At some point, however, you might want to create another instance. For example, you can isolate a development environment from a production environment by defining a different instance for each. To create additional instances, use the instance creation tool (DB2ICRT). See the Quick Beginnings book for your platform.

The instance must be started on the server before you can perform operations on it or its databases. The DB2 Control Center automatically starts the local instance you select if it is not already started. However, you might want to use the Control Center to stop or start a different instance; for example, if you want to start a remote instance as a test, or if you have changed configuration parameters at the instance level. (Instance-level configuration parameters take effect when you start the instance.) The steps are provided below.

Note that at installation time you can select an option to indicate that you want the default DB2 instance started each time the system is started. As well, from the Tools Settings window in the Control Center (select the Tools Settings icon from the Control Center toolbar), you can select to automatically start the local DB2 instance whenever one of the administration tools is started.

To start an instance:

  1. Select the instance.

  2. Click on it with mouse button 2.

  3. Select Start.

To shut down all activity on an instance:

  1. From the Control Center, select one or more instances you want to stop. Their database(s) will be shut down.

  2. Click with mouse button 2 on any of the instances you selected and select Stop from the pop-up menu. The Confirm Stop window opens listing all of the instances that you selected.

  3. Optional: To disconnect all applications from selected instances, select the Disconnect all applications check box.

    If any applications are running that affect database integrity, these applications will complete before the instance stops.

  4. To stop all of the instances selected in the box, click on OK. Any unselected instances are left untouched.

At this point, you can shut down the operating system if you need to.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]