DB2 Version 9.7 for Linux, UNIX, and Windows

Stopping instances (Linux, UNIX)

You might need to stop the current instance of the database manager.

About this task

Restrictions

The db2stop command can be run only at the server.

No database connections are allowed when running this command; however, if there are any instance attachments, they are forced off before the instance is stopped.

Before you begin

To stop an instance on your Linux or UNIX system, you must do the following:

Log in or attach to an instance with a user ID or name that has SYSADM, SYSCTRL, or SYSMAINT authority on the instance; or, log in as the instance owner.
Display all applications and users that are connected to the specific database that you want to stop. To ensure that no vital or critical applications are running, list applications. You need SYSADM, SYSCTRL, or SYSMAINT authority for this.
Force all applications and users off the database. You require SYSADM or SYSCTRL authority to force users.
If command line processor sessions are attached to an instance, you must run the TERMINATE command to end each session before running the db2stop command.

Procedure

To stop an instance on a Linux or UNIX operating system:

From the command line, enter the db2stop command. The DB2® database manager applies the command to the current instance.
You can use the db2stop command to stop, or drop, individual database partitions within a partitioned database environment. When working in a partitioned database environment and you are attempting to drop a logical partition using the following command:
```
    db2stop drop nodenum <0>
```
You must ensure that no users are attempting to access the database. If they are, you will receive an error message SQL6030N.
Note: When you run commands to start or stop an instance's database manager, the DB2 database manager applies the command to the current instance. For more information, see Setting the current instance environment variables.
From IBM® Data Studio, open the task assistant for stopping the instance.