Stopping databases

Use the Stop Databases window to stop selected DB2 databases. This makes the databases unavailable for applications and closes their data sets. You can check the status of databases 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 selected databases:

  1. Open the Stop Databases 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. Optional: If you decide against stopping a particular database, clear the check box under the Stop column next to the database name. You can also use the Check all or Uncheck all push buttons to set or clear all the check boxes for all selected databases. Only the databases with checks in the Stop column will be stopped.

  4. Click OK to stop the databases.