Stop Database

From DBArtisan
Jump to: navigation, search

Go Up to Available object actions by DBMS

The Stop Database dialog lets you stop a database, optionally letting you allow running applications access until their next COMMIT.

Platform Availability

To Stop a Database

1. On the DBArtisan Datasource Explorer, select the Databases or Tablespaces node or in the Datasource Navigator expand one of those nodes.
2. Right-click the target object and select Stop Database from the context menu.
The Stop Database dialog opens.
3. Use the following table as a guide to understanding and settings options on this dialog:
Option Functionality

Database Grid

The Partition column is editable and can include one or more unique numeric values separated by commas. Initially the Partition column is blank. No validation is made for the correctness of partition numbers so make sure that the partitions exist.

Stop at COMMIT

Enabling this option sends the STOP DATABASE statement.with an AT(COMMIT) clause, allowing running applications to continue access until their next commit.

4. Click Execute. For information on the scheduling option, see Scheduling.