Start Database

From DBArtisan
Jump to: navigation, search

Go Up to Available object actions by DBMS

The Start Database dialog lets you start a database:

  • When the database that has been stopped with a Stop Database dialog. For more information, see Stop Database.
  • After a tablespace, partition, or index has been placed in group buffer pool RECOVER pending status (GRECP) or if pages have been put on the logical page list (LPL) for that object.

Depending on the specified options, the database can be made available for read-only processing, read-write processing, or utility-only processing. In a data sharing environment, the command can be issued from any DB2 on the group that has access to the database.

Platform Availability

To Start a Database

1. In 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 Start Database from the context menu.
The Start Database dialog opens.
3. Use the following table as a guide to understanding and settings options on this dialog:
Option Description

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.


Lets you select access options of Read/Write, Read only, Utility only or Force.

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