SYS_TABLEMODES

SQL Guide : Database system tables and system views : System tables : SYS_TABLEMODES

SYS_TABLEMODES

Column name	Data type	Description
ID	INTEGER	Relation identifier.
MODE	WVARCHAR	Concurrency control mode (allowed values: OPTIMISTIC, PESSIMISTIC, MAINMEMORY, or MAINMEMORY PESSIMISTIC).
MODIFY_TIME	TIMESTAMP	Last modify time.
MODIFY_USER	WVARCHAR	Last user that modified.

SYS_TABLEMODES shows the mode only of tables for which the mode was explicitly set. SYS_TABLEMODES does not show the mode of tables that were left at the default mode. The default mode for D-tables is optimistic unless you set the solid.ini configuration parameter General.Pessimistic to “Yes”. M-tables are always pessimistic.

To list the names and modes of tables that were explicitly set to optimistic or pessimistic, execute the command:

SELECT SYS_TABLEMODES.ID, SYS_TABLEMODES.MODE, SYS_TABLES.TABLE_NAME

FROM SYS_TABLEMODES, SYS_TABLES

WHERE SYS_TABLEMODES.ID = SYS_TABLES.ID

AND SYS_TABLES.TABLE_NAME = '<table_name>';

The output will look like:

ID    TABLE_NAME    MODE
--                  ----
10054 TABLE2        OPTIMISTIC
10056 TABLE3        PESSIMISTIC

For more information about setting the concurrency control mode, see Setting the concurrency (locking) mode to optimistic or pessimistic.