DB2 10.5 for Linux, UNIX, and Windows

Stopping instances (Linux, UNIX)

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

Before you begin

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, use the LIST APPLICATIONS command.
Force all applications and users off the database by using the FORCE APPLICATION command.
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.

About this task

When you run commands to start or stop an instance, the DB2® database manager applies the command to the current instance. For more information, see Setting the current instance environment variables.

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.

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.
From IBM® Data Studio, open the task assistant for stopping the instance.