Start Database

Go Up to Available object actions by DBMS

The Start Database dialog lets you start a database:

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

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

Platform Availability

• DB2 z/OS

To start a database

1. In 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 then 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.
Access	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.