Quiescing tables

You can change the quiesce mode of a table and its table spaces. When you quiesce a table and its table spaces, locks are placed on the table and table spaces. The type of lock depends on the quiesce mode.

• To change the quiesce mode for a table using the Control Center:
  1. Open the Quiesce window: From the Control Center, expand the object tree until you find the Tables folder. Click the Tables folder. Any existing tables are displayed in the pane on the right side of the window. Right-click the table you want and select Quiesce from the pop-up menu. The Quiesce window opens.
  2. If you are turning on the quiesce mode or updating the quiesce mode to a higher mode:
     1. Make sure that the Quiesce radio button is selected.
     2. Select one of the following three modes:

        Shared

        Puts the table in shared mode. In this mode, all users (yourself included) can read but not change the table data.

        Intent to update

        Puts the table in update mode. In this mode, only you can update the table data. Other users can read, but not update the data.

        Exclusive

        Puts the table in exclusive mode. In this mode, only you can read or update the table data.

        If the table is already in one quiesce mode, you can change it to a higher (more exclusive) mode. For example, if the table is already in shared mode, you can change it to intent to update, or to exclusive mode.

        However, you cannot change a higher mode to a lower mode. Exclusive is higher than intent to update, which is higher than shared.

  3. If you are resetting a table's quiesce mode, select the Quiesce reset radio button.
• To change the quiesce mode for a table using the command line, use the QUIESCE command.