Starting indexes and table spaces

Use the Start window to start an index or table space.

Authorities and privileges

To start an index:

  1. Open the Start window.
  2. Specify an access option.
  3. If you select one partitioned space, specify partition information.
  4. Optional: Specify which spaces you want to start.If you select more than one object, then the selected spaces are displayed in a table. The Stop column in this table contains a check box. The remaining column entries show information about each index. By default, the Stop check box is selected. If you do not want to stop an index, click the Stop check box to deselected it. To act on all the indexes displayed in the table, use the Check all and Uncheck all push buttons.
  5. Click OK.

Related information

Specifying access options

To specify access options, select one of the Access option radio buttons:
Read and write allowed
Applications can read from and write to the specified indexes.
Read only
Applications can read from the specified indexes. Any application attempting to write to the index will fail.
Online utilities only
Only DB2 online utilities can access the index.
Important: The restricted access options, Read only and Online utilities only, take effect differently depending on whether an application starts during or after the START command has completed. The access restrictions take effect immediately for applications started after the START command completes. For applications that are executing when the START command is issued, the access restrictions take effect on a subsequent request. Depending upon the type of restricted access, drain activity, and whether there are held cursors on the space or partition, applications might be interrupted.
Force full data access
Applications have full access to read and write data. This option resets indications that the index is unavailable. An index started with this access option might be in an inconsistent state
Important: An index started with this access option might be in an inconsistent state. This option is intended for use when data has been restored to a previous level after an error, by DSN1COPY, or by a program that is not DB2.

Specifying partition options

To specify partition options:
  1. In the General page, under Start partitions, select a radio button:
    Selected
    Start only the spaces specified in the Partitions page.
    If you select Selected, OK is unavailable until you specify a partition.
    All
    Start all the partitions in the space. If you select All, the Partitions tab is unavailable.
  2. If you select the Selected radio button, select the Partitions tab.If you select All, this tab is unavailable.
  3. In the Partitions page, select the partitions that you want to start. To select a partition, click the check box that corresponds to the partition.