Stopping a database

Use the Stop Database window to stop one or more DB2 database. This makes the database unavailable for applications and closes the databases' data sets. You can check the status of a database by right-clicking on the Database folder and selecting Display from the pop-up menu. A status of STOPP indicates that the object is in the process of being stopped. A status of STOP indicates that the stop has completed and the object is in a stopped state. An object is not stopped until all currently active threads accessing the object are quiesced.

Authorities and privileges

To stop a database:

  1. Open the Stop Database window.

  2. Specify whether to allow currently running applications to continue accessing the database until their next commit. The status of the database is changed to STOPP status to prevent access from new requesters. After commit, further access by the committing application is prohibited. The database is actually stopped when all jobs release their claims on those objects and all utilities release their drain locks on those objects.

  3. Click OK to stop the databases.