Stopping indexes and table spaces

Authorities and privileges

To stop an index:

1. Open the Stop Index window.
2. If you want to specify that DB2 wait until the indexes next commit to stop the selected indexes, select Wait for currently running applications to commit.
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

• Altering an index
• Displaying reports about indexes
• Starting indexes

Specifying 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. 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.