DB2 Version 9.7 for Linux, UNIX, and Windows

Starting instances (Windows)

You might need to start or stop a DB2® instance during normal business operations, for example, you must start an instance before you can perform some of the following tasks: connect to a database on the instance, precompile an application, bind a package to a database, or access a host database.

About this task

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.

The db2start command will launch the DB2 database instance as a Windows service. The DB2 database instance on Windows can still be run as a process by specifying the "/D" switch when invoking db2start. The DB2 database instance can also be started as a service using the Control Panel or the NET START command.

When running in a partitioned database environment, each database partition server is started as a Windows service. You can not use the "/D" switch to start a DB2 instance as a process in a partitioned database environment.

Before you begin

In order to successfully launch the DB2 database instance as a service from db2start, the user account must have the correct privilege as defined by the Windows operating system to start a Windows service. The user account can be a member of the Administrators, Server Operators, or Power Users group. When extended security is enabled, only members of the DB2ADMNS and Administrators groups can start the database by default.

Procedure

To start the instance:

From the command line, enter the db2start command. The DB2 database manager applies the command to the current instance.
From IBM® Data Studio, open the task assistant for starting the instance.