Modes

If you are quiescing the table's table spaces, select one radio button to specify the mode you want the table spaces to be in:

Shared

Puts the table in shared mode. When the table is in this mode, all users can read but not update the table data.

Intent to update

Puts the table in intent to update mode. When the table is in this mode, you can update the table data, but other users can only read the data.

Exclusive

Puts the table in exclusive mode. In this mode, you have exclusive access to the table and its table spaces; other users cannot 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.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]