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.
See also
System tables