2.10.5 Base tables for which a lock is obtained when dictionary tables and system tables are referenced

When SQL statements are executed to reference dictionary tables and system tables, a lock is obtained for the dictionary tables (base tables) and system tables (base tables). The following table describes the base tables for which a lock is obtained when dictionary tables and system tables are referenced.

Table 2‒16: Base tables for which a lock is obtained when dictionary tables and system tables are referenced

Legend:

P/E: The resource is locked in shared retrieval mode (SR) during preprocessing and execution of the SQL statement. If the target resource has already been locked in exclusive mode (EX) when the SQL statement is executed, the statement is placed in wait status until the resource can be reserved.

E: The resource is locked in shared retrieval mode (SR) when the SQL statement is executed. If the target resource has already been locked in exclusive mode (EX), the statement is placed in wait status until the resource can be reserved.

P: The resource is locked in shared retrieval mode (SR) during preprocessing of the SQL statement.

--: No lock is obtained for the target resource.

To Page Top